DateAdd Function using existing field values

The Archn00b

Registered User.
Local time
Today, 01:34
Joined
Jun 26, 2013
Messages
76
I have a query in design view that consists of two calculated fields at the moment. One of the calculated fields is supposed to add one year onto a value from another date/time field called "Last_Date."

The expression I've written in the "Field:" box in Query design view is

Expr 2: DateAdd('yyyy',1,[Last_Date])


When I try to run the Query it doesn't work! Access just prompts me to enter a parameter value for Last_Date.

Any ideas? It has to be something simple.

Thanks for reading!
 
Make sure you are referencing the Field properly, this include spell check, and at times duplicate fields..

If the Query is a TOTALS Query make sure the Option under the Expr 2 is set to Expression and not Group By..
 

Users who are viewing this thread

Back
Top Bottom