98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Undo Entries In RecordsTo Undo any entries or changes in records: |