Forum home » Delegate support and help forum » Microsoft Access Training and help » access course - Amending date value
|
|
|
The UK's most regular 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 course - Amending date value
Resolved · Low Priority · Version Standard
Reply Tue 24 Jul 2007, 14:22Delegate Dee said...
For upcoming training course dates see: Pricing & availability
RE: amending date value
Hi Dee,
Do you want to view the date or the time?
A simple way is to set the FORMAT of the field to Date or Time format. In that way, you will only see the relevant part of the data. You could also add a input mask, to further structure the view.
Reply Wed 1 Aug 2007, 10:30Delegate Dee said...
RE: amending date value
Thanks Richard,
I want to view the date, I've used your suggestion when it is a one off table.
I'm creating tables through queries so the formatting changes when I refresh the queries, so thought there may be a formula I could put into the query so I don't have to amend the tables each time.
RE: amending date value
Hi Dee
If you right click on the date field in the field section of design view, you should be able to set the format.
Let me know if that works for you or not.
Regards
Richard
|