Help with a report (?)

[Robert Mador]

Hello

I apologize if this question has been asked before. I'm new to using Access and I'm responsible for keeping a database of approximately 150 employees. One of the things I want to do is run a report that will give me the retirement date for those employees.

That date will be 20 years from the day they joined. Is there an easy way of automating that function? I envision a menu option that I can select once a month and the database letting me know of any impending retirements within the next six to eight months

Keep in mind I barely know how to use Access. I have no programming experience. So if there is a tutorial out there that I can use that would be my best bet I believe

I appreciate any help with this that anyone can provide

Sincerely

Robert Mado

 

[Guest]

You can create a report based off of a query. The query
can do the date comparisons and manipulations for you.

You can create a field in the query like:
retiredt:dateadd("yyyy",20,(hiredt)) with criteria like
between date() and dateadd("m",8,date())

Retiredt will be hiredt plus 20 years. Only Retiredt
between today and 8 months from now will be selected.

-----Original Message-----
Hello,

I apologize if this question has been asked before. I'm

new to using Access and I'm responsible for keeping a
database of approximately 150 employees. One of the
things I want to do is run a report that will give me the
retirement date for those employees.

That date will be 20 years from the day they joined. Is

there an easy way of automating that function? I envision
a menu option that I can select once a month and the
database letting me know of any impending retirements
within the next six to eight months.

Keep in mind I barely know how to use Access. I have no

programming experience. So if there is a tutorial out
there that I can use that would be my best bet I believe.