Your query would be as you noted and you can run this daily as part of your routine.
Bob
I have a Microsoft Database in Access, I have a lot of Fields and reports to go through daily, is there any way I can set up a "Message Box" to remind me that a field had been left blank after a certain number of days. Such as, after I open a "case" after 30 days a message will appear saying that the case is still open. ...to remind me to resolve the issue...something along that ...if i cant do it in access is there any other database that can give me this "ticker" option?
Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic