duplicate records

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

Guest

How can I make a query not show duplicate records? Example, I have a query
that has one field which is "type" and it is assending. Records one throught
five may be the same, say apples and the next few records might be trees.
How can I get the query to only show one of the records for apples and one
for trees?

Thanks.
 
I put the word Distinct in the criteria line and got back no records? How
should the selcect statement look?

Thanks.
 
Use a select statement with the keyword Distinct. This will show only one
instance of your "type" field.
 
Look in the query properties (select a column that is not returning any data
and press the properties button).

HTH;

Amy
 
Open your query in SQL View and tpye the code there. You can then run the
query to see if you get the correct results.
 
I did? Here is my code. What do you think I'm doing wrong?

Thanks.

SELECT DISTINCT History.[Dist Cust]
FROM History
WHERE (((History.[Dist Cust]) Is Not Null));
 
Back
Top