Recent content by CarrieW

Here it is.... SELECT [Main Table].[LAST NAME:], [Main Table].[SATE DATE:], [Main Table].[LOAC DATE:], [Main Table].[ANTI-TERRORISM DATE:] FROM [Main Table] WHERE ((([Main Table].[SATE DATE:])<Date()-365 Or ([Main Table].[SATE DATE:]) Is Null)) OR ((([Main Table].[LOAC DATE:])<Date()-365 Or...

What it appears to be doing is pulling up all the records that have a null field in them therefore showing the dates that are both overdue and not overdue. I took out the "is null" in the query and now no records show up. I just tried updating my own record (where all my dates are current) to...

Oops, LOL I meant -365. Yes, the null is necessary because if I don't have a date on file for them completing the training I need to know that. That's why I put that in there. And no, right now I have 2 individuals who I have no dates for on any of the 3 training requirements and a couple of...

Thank you so much! That did get me a step closer, however now I have a new issue. LOL I put <Date()-356 Or Is Null under each date area on different lines to make it an "or" query which pulled up more names however now it's showing names that are NOT more than a year old. Is there something else...

I have a very simple database to track training and I am having trouble getting it to pull up the information I want. What I have is 3 types of training that need to be done yearly. I want to be able to go in once a month and pull up a report "training due this month" and have it pull up all...