Appending a Year to a field

Mickster

Registered User.
Local time
Today, 11:31
Joined
Feb 10, 2005
Messages
38
Hi there,

I am making a db that will store complaints for an institution. I currently have a Complaint ID field, however I want to append the current year to the Compalitn ID field.

i tried the following:

Me.f00 = Year(Now()) & f00,

but got an error.

Any suggestions.
 
Try: = CStr(Year(Now())) & CStr(Me.f00)
 

Users who are viewing this thread

Back
Top Bottom