duplicate records

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

 

[MH]

SELECT DISTINCT type
FROM MyTable

MH

 

[Guest]

Where do I put this code? In the criteria box of my query?

Thanks.

 

[Guest]

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

Thanks.

 

[Guest]

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

 

[Amy Blankenship]

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

HTH;

Amy

 

[Guest]

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.

 

[Guest]

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