combine todays date with a txt field in access update query

[gdesreu]

I have an update query that pulls initials from a form. I would like to add todays date to that initial. I keep getting mismatches no matter what format I try. Obviously Im missing something. Anyone have the answer? I would like to do this in an expression.
Thanks

 

[Ruddles]

Could you show us your query?

 

[Joe4]

Please post the current Update Query code that you have that successfully pulls the initials from the Form, and we can help you amend it.

 

[gdesreu]

Please post the current Update Query code that you have that successfully pulls the initials from the Form, and we can help you amend it.

Thanks guys, I figured it out this is it

"Unit Converted from " & [Forms]![frm_unit_conv]![Combo0] & " to " & [forms]![frm_unit_conv]![Combo7] & "_" & [Forms]![frm_unit_conv]![Text20] & "_" & Format(Date(),"@")