access reprots

[denise742]

I have a report set up in Access called "weekly report" - I want to go in and
tell the report that I only want a certain date, example, 1/1/2005 to
1/7/2005 - can I do this after the report is already created?

 

[Guest]

hi,
yes.
it is the query behind the report that does this.
open the report's record source query in design mode.
in the date field's criteria line, enter someth like

=[enter a start date] and < [enter an end date]

or
Between >=[enter a start date] and < [enter an end date]
both should work.

 

[CyberTaz]

The easiest way is to create a Parameter Prompt Query that prompts for the
date criteria & includes all the same fields used in the Report. Then change
the Record Source Property of the Report to use the Query instead of whatever
it was previously set to. Whenever run the report will prompt for the date
values.

Parameter Criteria on first Criteria row of Date field in query: Between
[start date request] and [end date request]

where start date & end date requests can be any message you want to appear
in the prompts when they come up.

Hope this is useful |:>)

 

[denise742]

Thanks but I'm having trouble finding out exactly where to go - do you mean
go to the main switchboard and pull up the actual report that I want to
modify? Where to I get to the date field's criteria line?

hi,
yes.
it is the query behind the report that does this.
open the report's record source query in design mode.
in the date field's criteria line, enter someth like

=[enter a start date] and < [enter an end date]

or
Between >=[enter a start date] and < [enter an end date]
both should work.

-----Original Message-----
I have a report set up in Access called "weekly report" - I want to go in and
tell the report that I only want a certain date, example, 1/1/2005 to
1/7/2005 - can I do this after the report is already created?
.