Multiple criteria query

[Guest]

I have a ten field query. I have criteria on the first field to refine the
query, this brings back 500 records which works fine.
I have another five fields which I need to add criteria to (Is not null and
not equal to 0). When I add this criteria I lose the refined results from
the first part of the query. How can I get this to work?
Thanks

 

[John Spencer]

I suspect that you need to put the criteria for the first field in every row
of criteria that you haved added.

By the way you only need to test for Not equal to zero - that will also
screen out nulls. Null values are never equal to or not equal to any value.

In the grid for two other fields you would have a set up that looked like:

Field: FirstField
Criteria(1): "X"
Criteria(2):

Field: Other1
Criteria(1): <> 0
Criteria(2):
========================
Field: FirstField
Criteria(1):
Criteria(2): "X"

Field: Other2
Criteria(1):
Criteria(2):<> 0


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..