Date Field plus X days

F

FJB

I have searched and not found THE answer to this problem. I have a date
field which I need to find the date a week later, i.e. Date to Close +
7 = DateToCheck. No matter what I try in the query to insert the
expression, whenever I run the query I am asked to supply a parameter.
This query has no parameters associated. What am I doing wrong?

Thanks for your help. You've have gotten me out of some tight spots
before, I am counting on you now.

Frank
 
M

Marshall Barton

FJB said:
I have searched and not found THE answer to this problem. I have a date
field which I need to find the date a week later, i.e. Date to Close +
7 = DateToCheck. No matter what I try in the query to insert the
expression, whenever I run the query I am asked to supply a parameter.
This query has no parameters associated. What am I doing wrong?

Thanks for your help. You've have gotten me out of some tight spots
before, I am counting on you now.
Click to expand...


When you have a question about a query, you should post a
Copy/Paste of the query's SQL view so we can see what you're
talking about.

I think(?) you can enter this in an empty field in your
query:

However it would be more rigorous to use:
DateToCheck: DateAdd("d", 7, [Date to Close])
 
Top