I want to have a report from a specified date to and another date, i cant get the report set up like this, can anyone give advice on how to set this up?

Your user is specifying the dates at the time of running the Report?

In the query underneath the report, put Between [Enter starting date] And [Enter ending date] in the criteria slot for your date field. Then run your report and see what happens. Alternatively you can get these values from a Calendar Control, or text boxes/combo boxes on an unbound form.

HTH,
David R


[This message has been edited by David R (edited 03-19-2002).]

do i type this in the query based on my table? as i have a lot of data going to be going into my database so i want to get a report for each month separately, can you tell me how i do this.

Can you group your data by month, and start each section on a new page?