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?

 

[ruralguy via AccessMonster.com]

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?

 

[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 via AccessMonster.com]

Your current query could also give you the date of their last review.
Instead of just checking a box you could create a button that enters a date
when the review is complete.

Could you explain how the process would work?

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.

[quoted text clipped - 20 lines]