Hello,

Can somebody give me an idea on how to specify a date range in the reports? :confused:

check out my sample here on my website which opens a report based on a date range entered in a form:

http://downloads.btabdevelopment.com/Samples/dates/ReportAndForm.zip

check out my sample here on my website which opens a report based on a date range entered in a form:

http://downloads.btabdevelopment.com/Samples/dates/ReportAndForm.zip

Thanks! Got the idea now :D

Good, glad it could help. By the way, Welcome to Access World Forums! :)

Good, glad it could help. By the way, Welcome to Access World Forums! :)

Thanks!

Oh, one more thing if it is alright... in the particular table I'm working on, the date field has a time with it. I don't need the time so how can read only the dates :confused:

Set up the report so that it is based on a query and not the table. Then you can create your date field by using

MyNewDateField:Format([YourDateField],"m/d/yyyy")

and that field you can use for the criteria.

Set up the report so that it is based on a query and not the table. Then you can create your date field by using

MyNewDateField:Format([YourDateField],"m/d/yyyy")

and that field you can use for the criteria.

Ok, Thanks again! :D