Queries using IIF statements

[jaarons]

Hi everyone,

I have a query that takes student names, allergies and medication from their student records. I want to tell access to include in the query only those records that have something EITHER in the alergies field OR in the medication fields from my Students table. Otherwise (if they don't) don't include them.

Thanks!

(That's the easier question, I'm now going to post a harder one . . .)

[June7]

Try criteria of Not Is Null under each field but on separate criteria rows.

[jaarons]

Worked a treat. Thanks June!