is there something to get rid of duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a query and i want to put something in the query to get rid of
duplicate recrods ? is there anyway to do this

loan #
12367
12367
1245
1268

i only want to show 12367 one time
 
you can try opening the properties of the query and changing "Unique
Properties" to yes.
 
when i hit the properties button in design view it doesnt give me anything
about unique properties
 
What Jeff C meant was Unique Values, not properties. Set Unique Values
to Yes.
 
Easiest way is to open the query in SQL VIEW (from design view select View:
SQL from the menu) and type the word "DISTINCT" immediately after the word
"Select"

SELECT DISTINCT YourTable.YourField ...

-- OR --

In the grid view, right-click on the grey area, select properties, change
unique values to Yes.
 
You must log in or register to reply here.

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 fails to eliminate duplicate information 4
Combine Duplicates in Query 0
Sorting out Duplicates 2
Using Social Security Numbers, but how do I get rid of duplicates. 4
Creating an index in a query 8
Cutting excess rows 2
Deleting Duplicates 1
How can I get rid of duplicates in a column? 2

Back
Top