summary

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i have a table and it has duplicate names in it, but i
only want to see the name once how can i query this?

example

Jones Jone
Jones
Frank Frank
Frank
Frank
 
Dan,

change your query to a total query the "group by" will do as you want.
Also, check your help files for "GROUP BY Clause" you should get some more
info there.

Hope this helps,

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to combine (group) text data 2
Total appointments per agent 2
"Query Too Complex" Access 2000 help me make this one query less complex? 0
Select with Conditions 4
Creating Multiple Records from Single Delimited Field 1
Multiple records in table to display single records 7
Delete a record every where there is duplicate 3
Query needed pls urgent 2

Back
Top