Duplicate Values in table

[senthilrg]

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

[tingletangle]

Hi, do you want to count the records ? or for what is 145 standing for ?

[tingletangle]

If you want to hide duplicate records, just select "functions" out of the view menu.
That's all.

[senthilrg]

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......