Re: Create a record on current mont

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. ;)

SoggyCashew wrote:
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
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200808/1

.