DateAdd Function using existing field values (1 Viewer)

[The Archn00b]

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!

 

[pr2-eugin]

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..