Report Filter

[Guest]

Is there a way to open reports so that a person can view only the reports for
a certain period of time, such as between 4 days ago and now?, my reports
currently do have a date attached to every one

 

[Rick B]

Sure, just change the criteria in the query upon which your form is based...

Between Date()-4 and Date()

 

[Rick B]

Make that "... upon which your REPORT is based."

 

[Guest]

Can I do that and make the from date something that can be entered when they
want so they can see only what they want

 

[Rick B]

Sure. Make your criteria...

Between [Enter Start Date:] and [Enter End Date:]

--
Rick B

Can I do that and make the from date something that can be entered when
they
want so they can see only what they want

 

[Guest]

Thank You
--
Dustin

Sure. Make your criteria...

Between [Enter Start Date:] and [Enter End Date:]

 

[rzwlkr33]

Is there a way I can do that without having someone enter in the criteria in
the query but something else like a form. I just want them to choose to view
a report dealing with only one person

Sure. Make your criteria...

Between [Enter Start Date:] and [Enter End Date:]

 

[JBrown]

I have been following this thread as I am trying to accomplish similar things.

When I changed the criteria as above and then opened the report, the report
prompted me for dates.

In my particular case I have a report which consists of 4 subreports. I am
hoping i can enter the date in only once and that will apply to all
subreports.

 

[JBrown]

Hi Rick,

Thanks for the info. I adjusted the query and of course I get a nice little
box asking for dates when I open the associated report.

Here is the new problem. The report in question actually consists of 4
subreports.

I am hoping the user can fire up the report and enter the date once and have
it apply to all subreports.

Any ideas?

Thanks,

Jude