having problems using multiple criteria in query...help

[Guest]

I have a query with multiple criterias in one or more fields. I have updated
this query to include yet another criteria in a different field and for some
wierd reason, it is not returning the value of my selected criteria. So
instead of returning back certain records, it gives me all records. The
field is Mail Type and the criteria choices are coming from a drop down menu:
E-Newsletter or Hard Copy. The criteria I entered is: = E-Newsletter and I
even tried <>Hard Copy. Both ways are producing no change/criteria specific
records.

To test the functionality, I created a dummy query and just only selected
the one criteria (i.e. E-Newsletter) and it returned back the correct
record(s). However, in the actual query that contains multiple criteria, it
doesn't work. Is there any sane reason why? Your help would be greatly
appreciated.

 

[Guest]

How are you adding the additional criteria? Are you in the design view grid?
Remember that criteria placed on the same row forms an AND function in that
both criterias must be satisfied. If you place the criteria on separate rows
then either will satisfy the requirement.

 

[Guest]

Yes, I am in design view. And yes, I isted the criteria on the same line/row
to evoke an AND function, meaning I want all criterias satisfied versus 'OR'.
Yet, it doesn't work. For instance, I want data that meet criteria in
COMPANY field of "USA" and in the MAIL TYPE field I want data that meet
criteria of E-newsletter. Yet when I run the query, it acts as if there is
no criteria for MAIL TYPE field, although it accepts the other listed
criterias (and yes, I have probably 4-5 other fields with AND criterias all
going at the same time)

 

[Guest]

Try doing the reverse. Save a copy of query under another name and then edit
so only MAIL TYPE field has criteria, run.

Build a little, test a little.