Amour22015
asked on
MS Access Query - Year minus one
Hi Experts,
I have this query:
intProgYear is only the year YYYY
I am getting:
On intProgYear = 2009
On Yearage = 7/1/1904
this is way off, I should get:
On intProgYear = 2009
On Yearage = 2008
Please help and thanks
I have this query:
Yearago: DateAdd("yyyy",-1,[intProgYear])
intProgYear is only the year YYYY
I am getting:
On intProgYear = 2009
On Yearage = 7/1/1904
this is way off, I should get:
On intProgYear = 2009
On Yearage = 2008
Please help and thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER