Making A Simple Report

E

emanuel.levy

If I have a field called that is used to see when a program began and I
want to create a report that shows when it is 90 days from the year
anniversary and then 60 days from the year anniversary how do I do
that?

I would want it to use the current date as the starting point.

Example if a report was generated on 11/5/05 I would want to see all
entries that were made 8/5/04 on the 90 day report and 9/5/04 on the 60
day report.

I would have this report run through a switchboard icon.
 
P

Pat Hartman (MVP)

Use a query as the RecordSource for the report. Add criteria that prompts
for the Number of days.

Select ...
From ...
Where Date() - [How many days?] >= DateValue(YourDate);
 
Top