Use previous date when date is a parameter

[Stevehewitt]

Hi Guys,

I have the following in my query criteria:

Between ([Forms]![frmReportDateSpecific]![txtStartDate]) And ([Forms]![frmReportDateSpecific]![txtEndDate])

However, I need the txtEndDate value to be one day earlier that the value that the user has entered in. E.G.

On the form frmReportDateSpecific, in the txtEndDate the user entered in 10/07/2005, I need the query to use 09/07/2005.

Any help appreciated.

Cheers,




Steve.

"They have the internet on computers now!" - Homer Simpson

 

[lupins46]

Between ([Forms]![frmReportDateSpecific]![txtStartDate]) And ([Forms]![frmReportDateSpecific]![txtEndDate]-1)