Create a record on current mont

S

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?
 
R

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?
 
S

SoggyCashew

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


ruralguy via AccessMonster.com said:
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?
 
R

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top