R
RipperT
Hello,
I am trying to write a parameterized query but can't get the syntax right. I
want the query to return all records containing a date exactly 14 days prior
to the date the user types in the parameter box. This isn't working:
WHERE (((tblCharges.AdSegDate)=[Enter Date:] -14));
An error message says the expression is typed incorrectly or is too
complicated to be evaluated.
Help!
Many thanx,
Rip
I am trying to write a parameterized query but can't get the syntax right. I
want the query to return all records containing a date exactly 14 days prior
to the date the user types in the parameter box. This isn't working:
WHERE (((tblCharges.AdSegDate)=[Enter Date:] -14));
An error message says the expression is typed incorrectly or is too
complicated to be evaluated.
Help!
Many thanx,
Rip