90 day eligibility

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a query for our employee database. I want to print a
report on the 15th of the month to see who will be eligible for benefits
beginning the 1st of the next month. For example: I want to see who all has
their 90 days in for the month of November because Dec 1st they get benefits.
I want to print the report on November 15th. This report will be printed
every month. Thanks for the help.
 
What exactly do you want? Tell us the math. Start date plus 90? Start
date plus 90 plus 15?

Rick B
 
They have to reach 90 days from their start date to between the 1st of the
month and the last day of the month (regardless if it's the 28th, 29th, 30th
or 31st). I'll be printing it on the 15th of the month. What I was trying
to do was a between date expression. If it couldprompt me to put in the
start of the month date and the end of the month date and then it'll tell me
who has 90 days in between there. Then it wouldn't matter what day I printed
it on.
 
Why not do something like this. Add a new column to your query and put in
the following:

EligMonth: Format([Birthdate]+90,"mmyy"


Then in the criteria put...

=[Enter MMYY desired]






I have NOT tested this, but it should work or get you pretty close.

Rick B
 
Thank you Rick. This works great!!!!!

Rick B said:
Why not do something like this. Add a new column to your query and put in
the following:

EligMonth: Format([Birthdate]+90,"mmyy"


Then in the criteria put...

=[Enter MMYY desired]






I have NOT tested this, but it should work or get you pretty close.

Rick B




Mandy J.S. said:
They have to reach 90 days from their start date to between the 1st of the
month and the last day of the month (regardless if it's the 28th, 29th, 30th
or 31st). I'll be printing it on the 15th of the month. What I was trying
to do was a between date expression. If it couldprompt me to put in the
start of the month date and the end of the month date and then it'll tell me
who has 90 days in between there. Then it wouldn't matter what day I printed
it on.
Click to expand...
Click to expand...
 
Back
Top