The Archn00b
Registered User.
- Local time
- Yesterday, 22:00
- 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!
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!