Tue 24 Jul 2007, 14:22Delegate Dee said...
Mon 30 Jul 2007, 12:25Trainer Richard said...
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.
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.
Fri 3 Aug 2007, 10:34Trainer Richard said...
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
