is there something to get rid of duplicates

[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

 

[Guest]

you can try opening the properties of the query and changing "Unique
Properties" to yes.

 

[Guest]

when i hit the properties button in design view it doesnt give me anything
about unique properties

 

[Jeff L]

What Jeff C meant was Unique Values, not properties. Set Unique Values
to Yes.

 

[Guest]

so how do i set this ? where is it located

What Jeff C meant was Unique Values, not properties. Set Unique Values
to Yes.

 

[John Spencer]

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.