Update Query Question

[Secret Squirrel]

I'm trying to add text to one of my fields in the following update query:

UPDATE tblVacationOverrides INNER JOIN tblEmployees ON
tblVacationOverrides.ID = tblEmployees.ID SET tblEmployees.VacationOverrides
= tblVacationOverrides.NetDaysAvail, tblEmployees.VacationOverrideReason =
"Carried over from 2007"
WHERE (((tblEmployees.VacationOverrides)>"0"));


How can I enter text that says "Carried over from: " and then have it enter
the previous year? Right now I have it set up to enter it all as text but I
want the previous year to be filled in automatically so I won't have to keep
changing it every year.

 

[tina]

try

"Carried over from " & Year(Date())-1

hth

 

[Secret Squirrel]

Thanks Tina!

 

[tina]

you're welcome

Thanks Tina!