View Full Version : Dates in reports


amd
11-26-2001, 12:49 PM
I have a database that takes in customers on a daily basis and after a while i need to print off reports for weeks the customers were entered.

I have managed to set up a weekly report but i want to select which week the report displays i.e. week 46.

Please help if you can, thanks

Harry
11-27-2001, 01:54 AM
First: Create an unbound form with one textbox. Call the textbox txtWeek. This is where you enter the weeknumber.

If your report is taking data directly from a table then you will need to create a query. If you already have a query, that's good. For the criteria of the week make it =[Forms]![FormName]![txtWeek]

HTH