Joining text with date 1

[ksdadguy]

Is there a function in Access similar to spreadsheet TEXT() function where I can extract the current year and add it onto the end of the text?

I have created some update queries in ACC2000 and they work fine. However, on one of the queries, I need to add the year onto the end of the text field.

The database is for a school where a promotion query is run to graduate the seniors with the result becoming:
Graduated-yyyy
where yyyy is current year

Here is what my sql code looks like now with the exception of adding on the value of the year:

UPDATE StudentInfo SET StudentInfo.Grade = "Graduated-"
WHERE (((StudentInfo.Grade)="Senior"));

Any help would be greatly appreciated

Thanks,
KSDadGuy

 

[r937]

SET StudentInfo.Grade = 'Graduated-'+format(date(),"yyyy")


rudy

http://r937.com/

SQL Consulting

 

[ksdadguy]

Rudy,

Thanks much for the answer, it works perfectly. I tried the format statement last night, but did not have it setup with the single quotes and double quotes.