Query or Not?

[Alastair MacFarlane]

Dear All,

Can anyone advise me of an easy way to give me the
following information:

TableA:
Field1
"Code", Text, 4
Field2
"Date", Date, Short Date

The scenario is that sites A, B, and C run an export every
day and the site and date of export is added to TableA.
Sometimes they forget and I would like to create a query
(?) that would identify missing sites and Dates. I could
create a master list of all sites and possible dates
through code on a daily basis and then create an unmatched
query, but is there an easier way to get this information?

Alastair MacFarlane

 

[Kailash Kalyani]

If I may make the assumption that all sites (3 different ones) make ONE
backup daily, then it should be a simple matter to group by date and count
the rows. If the number is less than 3, then you have a missing entry there.

To get into more detailed reporting you'd probably need more complex
queries or code, perhaps.

Kailash Kalyani
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC
--------------------