How to connect criteria from multiple fieldsets?

[Delta223]

Hi,

I'm new to using Access (2010). I understand how to use a query to exclude data that draws criteria from only one fieldset. But I don't know how to create a criteria that uses more than fieldset. For example:

Fieldset 1: Animal Group
Fieldset 2: Nickname

Say I want to exclude all felines that have been given a nickname

Field 1 criteria: ="Feline"
Field 2 criteria: Is null


How do I tell a query to connect these 2 criteria together?

I've tried entering both criteria and they do not seem to be accepted together. For the above example, ONLY records that are marked as Feline with fieldset 2 null, would be shown in the query.

Thanks for any help

[orange]

Please explain fieldset. Do you mean Table?

[Delta223]

No, the column header (where you set the column label and type)

[orange]

Let's work thru what you're asking.

Say I want to exclude all felines that have been given a nickname

to me means

Give me everything that is NOT ( Felines that have a nickname)

So find all the records/rows that are NOT Felines with Nicknames

SELECT * 
FROM YourTable
WHERE  NOT
(AnimalGroup = "Feline" AND Nickname IS NOT NULL)

All AnimalGroups , regardless of Nickname or not, as long as
we exclude (Felines with Nicknames)

[Delta223]

Thanks, that sounds simple enough. I'm very new to the program - where do I insert that code? The "Criteria" area of the query screen can not fit multiple lines like how your code is shown

[orange]

Here's a jpg of the criteria in my Acc2003 query.

My table is tblXXXX --- it is shown on the jpg also.

[Delta223]

I get it now; Thanks orange!

[orange]

Your welcome. Glad to help.