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 . . .)