Reporting

[slifer666]

I want to create a report that will generate from a specific date then have as the second criteria i want the date to change to what ever the current date is

Is this even possible or am i just wishing????

Anyone able to help?

 

[battenberg]

create a form (frmDateRange) to input your date ranges:
have two text boxes
txtStartDate & txtEndDate

in your query,that the report depends on, under the 'date' criteria use:

Between [Forms]![frmDateRange]![txtStartDate] And [Forms]![FrmDateRange]![txtEndDate]

you can then assign whatever dates you want, or set one or both of the dates as static/current etc..

if you want to always assign the current date to the txtEndDate box, format it as a date, then use: =Date

 

[slifer666]

Cheers mate, that worked brilliantly

Woo. My database is starting to come together now