DateAdd Function using existing field values (1 Viewer)

The Archn00b

Registered User.
Local time
Yesterday, 16:13
Jun 26, 2013
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!


Super Moderator
Local time
Today, 00:13
Nov 30, 2011
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 (Users: 0, Guests: 1)

Top Bottom