Query to list delinquent entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help with a query that will provide a list of delinquent entries.

I have an “INDICATOR†table with a field named “Indicator#†and a “DETAIL
RECORDS†table that also has a field with the “Indicator#†and a field named
“DateOfData†– along with many other fields. I need a query that will
provide a list of all the records from the INDICATOR table that do not have
entries in the “DETAIL RECORDS†table greater than a date that will be
entered in the “DateOfData†field of the query.

If I have not made my problem clear, or if you need more info to help me,
please so inform.

I am very much a novice and will greatly appreciate any help offered. Many
thanks in advance.
 
Step 1) Start by using the Query wizard (create an 'unmatched' query)
Step 2) Modify this query to include your specific criteria.

If you need further help with step one or two, please respond to this post
Hafeez Esmail
 
Back
Top