duplicate records

R

rml

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.
 
R

rml

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

Thanks.
 
M

matt22

Use a select statement with the keyword Distinct. This will show only one
instance of your "type" field.
 
A

Amy Blankenship

Look in the query properties (select a column that is not returning any data
and press the properties button).

HTH;

Amy
 
M

matt22

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.
 
R

rml

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));
 
Top