Making A Simple Report

[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.

 

[Guest]

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);