Running a query/report automatically from a calculated date

P

Pat H

Is there a way to have a query or a report automatically run from a calcuated
date that does not have to be entered from a start date que? I have a date
in my query that I have calculated. It's an anniversary date, which is
calculated from a person's hire date. I want a report to automatically run
from this anniversary date to the next anniversary date without asking for
the dates to be entered. I do not know anything about creating macros or
modules, etc.

Thanks
 
J

Jeff Boyce

Pat

Not sure I completely understand.

Are you saying that you want a query to run that uses a date value already
stored in your table as a criterion? Are you saying you want to be able to
have an Access query add one year (for example) to a date in a table, and,
if today is that (calculated) date, return a record?

That sounds like a standard criterion query, plus using the DateAdd()
function.

Or have I misunderstood?

Regards

Jeff Boyce
<Access MVP>
 
P

Pat H

The dates I want to use are not stored in a table, but calculated in a query
from another date which is stored in my table. I don't want to have to enter
the dates but have access run the query using the calculated dates when an
employee name is input. In other word, can i get acess to recognize the
dates automatically and run the query when I input a name.
 
Top