Create a record on current mont
- From: SoggyCashew <SoggyCashew@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Aug 2008 11:38:01 -0700
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?
--
Thanks,
Chad
.
- Follow-Ups:
- Re: Create a record on current mont
- From: ruralguy via AccessMonster.com
- Re: Create a record on current mont
- Prev by Date: RE: Null or No Null values in a parameter query
- Next by Date: Re: change from inches to feet
- Previous by thread: linked table using multiple delimiters
- Next by thread: Re: Create a record on current mont
- Index(es):