Correct syntax Please

  • Thread starter Thread starter Dar
  • Start date Start date
D

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
 
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.
 
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
Click to expand...


.
Click to expand...
 
Back
Top