Appending a Year to a field

[Mickster]

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.

 

[edtab]

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

 

[Pat Hartman]

Storing concatenated values is poor practice and violates first normal form. I assume that you have a date field for the complaint so you have everything you need. If you want to prefix the id field when you display it that's fine.

Year(ComplaintDate) & f00