Dates in the future

[jamesb]

I am finishing up a db that needs to have a field in a table that is 15 ahead
of the date entered into another field.
I have entered =DateAdd("y", 15,[Issue Date]) into the query and absolutely
nothing comes back. What am I missing, or where should I be putting this
value/expression if not in the query?

THanks in advance

 

[Tom van Stiphout]

On Fri, 21 Nov 2008 18:16:03 -0800, jamesb

15 what? "y" is not for Year.

-Tom.
Microsoft Access MVP

 

[jamesb]

Oops! didn't proofread my question. Days...15 days.

Thanks again

I am finishing up a db that needs to have a field in a table that
is 15 ahead of the date entered into another field.
I have entered =DateAdd("y", 15,[Issue Date]) into the query and
absolutely nothing comes back. What am I missing, or where should
I be putting this value/expression if not in the query?

THanks in advance

The syntax of your calculation is for use in an unbound textbox on a
form or report, not a query.

In a query, you must give the column a name, terminated with a colon
instead of the equals symbol, then the expression.

And as Tom pointed out, the expression is wrong.

Plus, you should rarely or ever store a calculated value in a table,
you always recalculate it when needed in the form or report, or in a
query.