Re: dynamic reporting

Create a form with two textboxes, to hold StartDate and EndDate.

Create a query that returns the data you want in your report, and includes
the sales/date info.

In the Criteria "cell" under the date field in the query, refer to the
form's controls, something like:
Between #Forms!YourForm!StartDate# And #Forms!YourForm!EndDate#

In design view of your report, point to the query you built above.

Put a command button on the form that opens the report.

NOTE: this approach only works if the form is open and there are values in
the Start/End fields.

Regards

Jeff Boyce
Microsoft Office/Access MVP

<san.r82@xxxxxxxxx> wrote in message
news:1169159079.253478.292700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
hii,
for example i have a report (in microsoft access) which displays the
sales of a small-scale industry from jan10th -06 to dec16 -06 and i
want the user to reuse the same report for displaying the sales from/to
particular date like may06 to aug06, coz if the user wants to take a
printout of the report and if he doesnt want all the sales from jan to
dec ,he should be able to select the data that is needed. is there
anybody who can help with this problem.



.

Loading