Edgar has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access VBA course
Update query for updating just the year part of date
I would be grateful if I could please have an SQL statement for an update query that tells Access to look at a date in one field and update only the year part of the date into another field. So for example if i have a field that has "Date of receipt" and a record in that field says 01/05/2010, I would like the corresponding record in the "Year of receipt" field to be updated to just 2010.
Many thanks,
Edgar
RE: Update query for updating just the year part of date
Hi Edgar
Thank you for your question. I'm sorry it has take a while for us to get an answer to you. We will get back to you as soon as one of our trainers is available to reply to your question.
Kind regards,
Andrew
RE: Update query for updating just the year part of date
Hello Edgar,
I am writing to check if the issue you mentioned on the forum was resolved.
If it was, great. If it wasn't, we can help if you let us know by respond to this message.
Kind regards
Cindy
Microsoft Office Trainer
