update query updating just

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Update query for updating just the year part of date

Update query for updating just the year part of date

resolvedResolved · High Priority · Version 2007

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

Thu 20 Dec 2012: Automatically marked as resolved.


 

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

View all Access hints and tips


Server loaded in 0.08 secs.