Query for all but one item

[Chip Asmus]

This must be a very beginner question... But I am stumped

I have a few tables... Customer which holds most of my information. Status
which is a list of 8 items. I have the two with relationship between the
status level on each field. The customer record is linked to status with a
drop down field to Status.

Now I want to run a query that shows everything BUT the completed status. I
tried <>"Completed" in criteria, but then I got seven listings for each
record. (when only one item was in the customer field)

Any help would be appreciated.

Chip Asmus
Lawlers Hallmark

 

[Guest]

try Not "Completed"

 

[Chip Asmus]

Tried that, and it shows everything from the status fields. In the customer
field it is selected "On Order" but the query shows the same record seven
times (all but completed.)

The field of status is a look up field in the customer table. It is tied to
Status. Maybe I set that up wrong?

Chip