update query updating just
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

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

Thu 9 Aug 2012, 12:39 replyReply Delegate Edgar said...

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

For upcoming training course dates see: Pricing & availability

Mon 13 Aug 2012, 14:56 replyReply Trainer Andrew said...

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

Thu 13 Dec 2012, 11:30 replyReply Trainer Cindy said...

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.

 

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips



MS Project training
Course rating:
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest