Specify Number after Parameter

[Bass71]

Hi;

I'm trying to create a query that outputs a group of dates 21 days prior to the date specified in parameter.

In the criteria field, I'm trying to write something like..

[Enter Date Inquiry Sent]-21

Thank you..........RO

 

[Melagan]

Though most would recommend against using parametric queries, opting for criteria to be specified in a form instead, here is a potential answer:

SELECT t.[YourDateField]
FROM tblYourTable t
WHERE ((DateDiff("d",[YourDateField],[Enter Date Inquiry Sent])=21));

(typed, semi-tested)


~Melagan
______
"It's never too late to become what you might have been.