Create a record on current mont

[SoggyCashew]

Hello, I have a query named qryYearlyReview and it gives me all the employees
whos Date Of Hire are in the current month. The fields are:

1) FirstName
2) LastName
3) DateOfHire
4) CurrentMonth: Month([DateOfHire]) Criteria: Month(Now())

I want to run something in my Main Form that would run this query and save
those names to a table named tblYearlyReview with these fields:

1) FirstName
2) LastName
3) DateOfHire
4) Completed "Check Box"

I want it so if there is already the same record then it wont create a new
one. This is so I can have a reminder that an employees yearly review is due
in the current month and when I check the completed box in the
tblYearlyReview then it wouldnt show again untill it creates a new record
next year. How would I do this?

 

[SoggyCashew]

Could you explain how the process would work?
--
Thanks,
Chad

I'm going to suggest you *not* create another table but instead just add a
DateTime field to the current table name LastReviewDate. Just my $0.02.

Hello, I have a query named qryYearlyReview and it gives me all the employees
whos Date Of Hire are in the current month. The fields are:

1) FirstName
2) LastName
3) DateOfHire
4) CurrentMonth: Month([DateOfHire]) Criteria: Month(Now())

I want to run something in my Main Form that would run this query and save
those names to a table named tblYearlyReview with these fields:

1) FirstName
2) LastName
3) DateOfHire
4) Completed "Check Box"

I want it so if there is already the same record then it wont create a new
one. This is so I can have a reminder that an employees yearly review is due
in the current month and when I check the completed box in the
tblYearlyReview then it wouldnt show again untill it creates a new record
next year. How would I do this?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com