How do I constrauct a query which fullfills a certain date criteria or a null

  • Thread starter Thread starter effendi
  • Start date Start date
E

effendi

I am creating a query for a person record which has a child "appraisal
record". The child appraisal record must be older than 6 months. or
return person record where there are no appraisal record.

Thanks in advance.
 
You could use this

CheckOnThisPerson: DateDiff("m", [AappraisalDate], Date())

Put 6 in the criteria line below and this will give you people who are due
for looking at.

Cant really see how you would make any querie to select records of people
who dont have a record (or appraisals). I may have misunderstood what you're
after - if you could give a bit more info I should be able to help.
 
Back
Top