J
Jeff
Hi everyone,
I have 2 tables that are one to many in relation. The first table stores the
personal data like name, date of birth, sex etc. of the babies. The second
table stores the vaccine injection records like vaccine name, injection date
etc. for those babies. Each baby may have none, one or more records of
injection. I'd like to build a query to retrieve those babies who are older
than a specific age and has NOT been given a specific vaccine after a
specific date. I put the following criteria in my query:
date of birth > #specific date# AND injection date > #specifc date# AND
vaccine name <> “Flu vaccineâ€
OR
date of birth > #specific date# AND injection date Is Null
With these criteria I can retrieve the babies who has not been given Flu
vaccine after a specific date and the babies who do not have any record of
vaccination. However, those babies with only vaccinated records BEFORE that
specific date, no matter what the vaccine is, can not be retrieved. Does
anyone have good idea to help me make up this part? Thank you.
I have 2 tables that are one to many in relation. The first table stores the
personal data like name, date of birth, sex etc. of the babies. The second
table stores the vaccine injection records like vaccine name, injection date
etc. for those babies. Each baby may have none, one or more records of
injection. I'd like to build a query to retrieve those babies who are older
than a specific age and has NOT been given a specific vaccine after a
specific date. I put the following criteria in my query:
date of birth > #specific date# AND injection date > #specifc date# AND
vaccine name <> “Flu vaccineâ€
OR
date of birth > #specific date# AND injection date Is Null
With these criteria I can retrieve the babies who has not been given Flu
vaccine after a specific date and the babies who do not have any record of
vaccination. However, those babies with only vaccinated records BEFORE that
specific date, no matter what the vaccine is, can not be retrieved. Does
anyone have good idea to help me make up this part? Thank you.