Correct syntax Please

[Dar]

I need to write a query under a date field with the end
result being this!

Between 10/10/04 And 10/15/04

I would like the user to only have to put in the last date
and have the query fill in the first date. It would
always be a 6-day range.

Please be specific on any punctuation I need and where

Thanks

 

[Douglas J. Steele]

Between DateAdd("d", -6, [Input End Date]) And [Input End Date]

Of course, a better approach might be to open a form with a calendar on it,
let them select the date from the calendar and then click on a button that
launches the query.

 

[Guest]

Thank you. I appreciate answer. Now have new post for
next step.

-----Original Message-----
Between DateAdd("d", -6, [Input End Date]) And [Input End Date]

Of course, a better approach might be to open a form with a calendar on it,
let them select the date from the calendar and then click on a button that
launches the query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I need to write a query under a date field with the end
result being this!

Between 10/10/04 And 10/15/04

I would like the user to only have to put in the last date
and have the query fill in the first date. It would
always be a 6-day range.

Please be specific on any punctuation I need and where

Thanks

.