Filtering a query

J

John

I have a table called Inventory that contains all the computers every
purchased. The list has many different models, and many computers are the
same model. How do I query this table to show me one of each type of model.

Ex.
Instead of seeing this:
Inspiron 9100
Inspiron 9100
Inspiron 9100
Inspiron 9100
Inspiron 700m
Inspiron 700m
Inspiron 700m

I want to see this:
Inspiron 9100
Inspiron 700m
 
D

Dennis

Assuming your query contains just this field as a column, click on the totals
button on the toolbar and this will put Group By in your column.
Run the query.
 
Top