Date format and auto number combo

[REDaughdril]

I have a query that I want the Now() function in the year only format and in an expression combine with the auto number one extra field to get the following:


date YYYY-------Autonumber---------color----------exp1:
---2007--------------23--------------green-------2007-23-green


Thanks for the help

 

[WayneRyan]

RED,

NewField: Format(Date(), "YYYY") & "-" & CStr([AutoNumberField]) & "-" & [Color]

Wayne