D
dreamsoul620 via AccessMonster.com
Hi all. I really hope someone can help me out with this. I have a database
that collects information about employee's attendance. They accumulate
points for violations. They can only have a certain amount in 60 days before
being fired. The 60 days is unique per employee. It starts from their first
violation and ends 60 days out from there. I have that much working great!
This week quite a few employees had reached their 60 day point and I have the
database set to archive if the current date is <= the end date of their date
range. I have 4 tables archiving at this point. Points, Date_Range, Summary,
and Warnings. The first three seem to work great. But the Warnings is
giving me trouble. The archive critieria for Warnings is as follows:
Acknowledge = Yes, Printed = Yes, Date <= Endate (end of range). This is an
And statement. The first time I ran the queries, everything looked fine.
Two people had yet to be acknowledge and had 13 and 21 points respectively.
Upon closing out and reopening the database, the points both changed to 8.
Warnings looks only at Points. In checking the Points table, there are no
occurences for either employee, nor do they even have a date range. I tried
adding in a Primary Key ID, but to no avail. If anyone knows what I am doing
wrong here, please help!
Thanks in advance for any suggestions or ideas.
that collects information about employee's attendance. They accumulate
points for violations. They can only have a certain amount in 60 days before
being fired. The 60 days is unique per employee. It starts from their first
violation and ends 60 days out from there. I have that much working great!
This week quite a few employees had reached their 60 day point and I have the
database set to archive if the current date is <= the end date of their date
range. I have 4 tables archiving at this point. Points, Date_Range, Summary,
and Warnings. The first three seem to work great. But the Warnings is
giving me trouble. The archive critieria for Warnings is as follows:
Acknowledge = Yes, Printed = Yes, Date <= Endate (end of range). This is an
And statement. The first time I ran the queries, everything looked fine.
Two people had yet to be acknowledge and had 13 and 21 points respectively.
Upon closing out and reopening the database, the points both changed to 8.
Warnings looks only at Points. In checking the Points table, there are no
occurences for either employee, nor do they even have a date range. I tried
adding in a Primary Key ID, but to no avail. If anyone knows what I am doing
wrong here, please help!
Thanks in advance for any suggestions or ideas.