Results 1 to 4 of 4
  1. #1
    senthilrg is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    8

    Thumbs down Duplicate Values in table

    Dears,

    I have problem in a query.

    I have table with data like

    FID T_Participant T_Validation P_NameID

    1 1 0 123


    1 1 0 145
    2 0 0 167
    2 0 0 189
    3 2 1 123

    I need result like this


    FID T_Participant T_VAlidation P_NameID
    1 1 0 123 145
    2 0 0 167 189
    3 2 1 123

    Like this....

    Pls help to get into

    Thank s

  2. #2
    tingletangle is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    4
    Hi, do you want to count the records ? or for what is 145 standing for ?

  3. #3
    tingletangle is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    4
    If you want to hide duplicate records, just select "functions" out of the view menu.
    That's all.

  4. #4
    senthilrg is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    8

    Wink RE:Queries

    Thank u for the response,

    145 is nothing but the id of a person, that doesnt matter i want the record in row wise, i dont want to count the number of records......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-09-2009, 11:52 AM
  2. Prevent Duplicate Values on Combination of Two Fields
    By LornaM in forum Database Design
    Replies: 8
    Last Post: 05-05-2009, 11:16 PM
  3. Replies: 0
    Last Post: 01-06-2009, 02:17 PM
  4. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 AM
  5. Duplicate add to new table
    By horseyshoe in forum Access
    Replies: 3
    Last Post: 09-01-2006, 07:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums