Good day Gents!
My problem is I have a database where I have recorded dates of when the employees last got certified for their forklift certifications (as well as others)...such as Person A - 8/11/2009, Person B - 9/2/2009, Person C - 7/2/2009, etc.
After a certain amount of time (let's say 6 months) they expire and the employee needs to be re-certified. So, on 2/11/2010, Person A needs to get re-certified, and then it would be entered as 2/11/2010 and 8/11/2009 would be erased. Okay...that's what it does.
The question I have is, I need to make a report/query that shows everyone from today's date that needs to get re-certified. Such as, today is 10/20/2009...if someone had their number at 4/21/2009, it would not show it, but tomorrow, when the report was ran, he would be on the list because it would have been 6 months since he last got certified. I am so hoping this makes sense...
So in essence, it would show everyone who is up for renewal. I checked online (googled) and all I kept finding was stuff for SQL or other programs.
Please, any help would be greatly appreciated
My problem is I have a database where I have recorded dates of when the employees last got certified for their forklift certifications (as well as others)...such as Person A - 8/11/2009, Person B - 9/2/2009, Person C - 7/2/2009, etc.
After a certain amount of time (let's say 6 months) they expire and the employee needs to be re-certified. So, on 2/11/2010, Person A needs to get re-certified, and then it would be entered as 2/11/2010 and 8/11/2009 would be erased. Okay...that's what it does.
The question I have is, I need to make a report/query that shows everyone from today's date that needs to get re-certified. Such as, today is 10/20/2009...if someone had their number at 4/21/2009, it would not show it, but tomorrow, when the report was ran, he would be on the list because it would have been 6 months since he last got certified. I am so hoping this makes sense...
So in essence, it would show everyone who is up for renewal. I checked online (googled) and all I kept finding was stuff for SQL or other programs.
Please, any help would be greatly appreciated