Then I would reccomend a good book on the subjectforgive me, i'm a novice. i have no idea what you're talking about. pretend i've just opened access for the first time in my life.
okay, here goes: i'm just creating a very simple access database, using what i believe to be the most recent version of ms office, on windows vista. one column is for dates. the only options i can see for displaying the date in a cell formatted for date/time, in the "format" menu on the "datasheet" tab, are "general date" (mm/dd/yyyy), "long date" (ridiculously long), "medium date" (dd-mmm-yy), and "short date" (mm/dd/yy). i want yyyy/mm/dd. i don't know what you mean by "if you have a date called datevalue then using format (datevalue, 'yyyy/mm/dd')." where can i find this option? or, where am i supposed to input it? hopefully this clears up how little knowledge i have of access. thanks...Then I would reccomend a good book on the subject
Seriously I thought In had given you a complete answer to your question.
If you have a date called
Format(DateValue,"YYYY/MM/DD") will display the date in that format.
Can you give a little more detail of what you want to do so we can help you
DateValue is an Access function. Using it as a field/variable name invites problems down the road.If you have a date called
thanks for the link, but neither that article, nor any that it links to, answers my question, as far as i can tell. my dates are in date/time format, not text format. i JUST WANT TO CHANGE THE ORDER in which the values are DISPLAYED from MM/DD/YYYY to YYYY/MM/DD. sorry if i'm being thick-headed about something but i'm no closer to an answer than when i first asked the question. thanks...Take a look at this MSKB article http://support.microsoft.com/kb/q130514/ showing how Access stores dates/times, provided they are in date/time data format -- not as formatted text. Strongly suggest you convert your text dates to date/time format. They you can format them as needed.
DateValue is an Access function. Using it as a field/variable name invites problems down the road.
That statement is definitely NOT TRUE. But, due to your limited knowledge you couldn't understand what Rabbie was telling you.as far as i can tell, there's no way to format JUST access dates the way i want them.
The advice you have been given is sound. It assumes however that you have an ability level of 1, not 0.forgive me, i'm a novice. i have no idea what you're talking about. pretend i've just opened access for the first time in my life.