Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to redundancy data (Access)

    Post deleted by aha

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to redundancy data (Access)

    <P ID="edit" class=small>(Edited by mbarron on 22-May-08 12:03. was missing the ] after first [FieldName])</P>Assuming your data is as posted - the name followed by a dash and then the number.

    Create a field using the following formula
    Name: Left([FieldName],InStr([FieldName],"-")-1)

    Group on the new field

    Replace FieldName with the actual name of your field

  3. #3
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to redundancy data (Access)

    I tried already but error.
    Left([Field1],InStr([Field1],"-")-1)
    I paste in Query at Criteria,right?

    I tried put Cases: Left([Field1],InStr([Field1],"-")-1)

    Still can't.
    Please help me again. THANK YOU SO MUCH

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to redundancy data (Access)

    See attached.
    Attached Files Attached Files

  5. #5
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to redundancy data (Access)

    Oh, Thank you so much mbarron.
    Am so happy and glad right now.
    Do you know i read book and search in google all day but still can't until i posted it.

    By the way, I would like say Thank you so much you so kind with me.

    Have a beautiful day.
    Thxs again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •