Look for missing/expired data

[pamk]

How can I set up reports or queries to look for -
1) multiple expired data (i.e., list an employee if any of the following
fields have an expired date: auto license, auto insurance, professional
license)
2) multiple missing date (i.e., list an employee if data is missing from any
field in a form)

Thank You!!

 

[Larry Linson]

How can I set up reports or queries to look for -
1) multiple expired data (i.e., list an employee if any of the following
fields have an expired date: auto license, auto insurance, professional
license)
2) multiple missing date (i.e., list an employee if data is missing from
any
field in a form)

(1) Create a Query including the date Fields of interest, and in the
Criteria, use <Date(). Put these criteria on Separate lines so they will be
ORd together rather than ANDed.

(2) Create a Query including the Fields of interest, and, on separate
Criteria lines, enter Null.

I don't understand why you call them "multiple" expired date or "multiple"
missing date, when you define _any_ expired or missing date as being the
criteria for selecting them.

Just for the record, data in relational databases is kept in Tables, and is
only entered/changed/displayed in Forms. The Queries, of course, will work
with the Tables, not with Forms.

Larry Linson
Microsoft Access MVP