Hello all. I need to run a report, but the report needs to show me data that doesn't exist. There are two tables involved, one static with all of our server names, one dynamic that holds the data for our Off Site Backups. I need a report that shows when an Off Site was NOT done, but I'm not sure how to pull it if there are no records. They need to be done monthly, so if the report is only able to be done monthly, then that would be OK. Ideally, I'd like a date range, but that may be too much (verify that it was done each month for this date range? No thanks!)
Table Server List
Home Server Name Type
Blah A Blah
Blah B Blah
Blah C Blah
Blah D Blah

Table Off Site Backup
Server Date Tech etc....
A 7/11 Jef
B 7/11 Jef
D 7/11 Jef

Report would have to show only

An Off Site Backup was not performed for C during month of July.
(obviously one for each server)

I'm lost. I know what I want to do, just not sure how to do it... :( :confused: :mad:

One more problem... I need to run an exclusion query (proper term - unmatched query). Here's the new issue... We have a total of 27 servers that backup daily. I need a report that shows the failures (that's easy). I also need one that shows the ones that were not filled out...

A B C D
1/1 O O X O
1/2 X O O
1/3 O O O O
1/4 X X O
1/5 O O O

I can't figure out an unmatched query, as the date / server name are both appearing more than once. What I need is For list A of servers and list B of dates, show me where server does not have a date associated with it. In the above example, I would need to see B on 1/2 and 1/5 and C on 1/4.

So we have 27 servers and (average) 22 working days per month, really rather not do 20+ queries...

Please assist!