Removeing Duplicates

[Guest]

What function can I use on Query Level to remove duplicate info

I am sure its simple , I have done something like this before a long time
ago....

example

Field1 Field2 Field3
ABC DEF 123
ABC DEF 456
ABC DEF 789
ABC GHI 123
ABC JKL 456
ABC JKL 789

need to display

Field1 Field2 Field3
ABC DEF 123
456
789
ABC GHI 123
ABC JKL 456
789

Jai

Thanks in advance

 

[Guest]

Hi Jai,

You do not want to remove such data at the query (or table) level. Doing so
would be "committing spreadsheet" with your data. You can, however, suppress
printing duplicates information in a report. There is a Hide Duplicates
property for text boxes.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Cheers for that

Jai

Hi Jai,

You do not want to remove such data at the query (or table) level. Doing so
would be "committing spreadsheet" with your data. You can, however, suppress
printing duplicates information in a report. There is a Hide Duplicates
property for text boxes.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________