Report Filter

D

Dustin

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
 
R

Rick B

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

Between Date()-4 and Date()
 
D

Dustin

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
 
R

Rick B

Sure. Make your criteria...

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

--
Rick B



Dustin said:
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
Click to expand...
 
R

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

Rick B said:
Sure. Make your criteria...

Between [Enter Start Date:] and [Enter End Date:]
Click to expand...
 
J

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

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
 
Top