This should be easy but I cant seem to get it.
I have a table that has three fields: AllowedCentury, AllowedYear and AllowedMonth. I created a new field called RealDate and I want to use the Century , Year and Month fields to update it .
I have tried to concatentate:
[AllowedMonth] & "/" & 1 & "/" & [AllowedCentury][AllowedYear]
But that doesn't work.
I have looked at using date part but it is in three different fields.
Any Ideas how to update this field using and update query and get a real date field entered?