SELECT tlbExpenses.ID, tlbExpenses.Category, Format([Date_Entered],"mmmmyy") AS MyDate FROM tlbExpenses;
I'm going to ask a dumb question. Can you provide an example of a value formatted that way: "mmmmyyyy"? What do you expect to see? We can guess about it, but given that "mmmmyyyy" might mean a couple of different things, I'd like to know for sure what you expect to see.I have a query with a date field named 'Date_Entered By Month' in the format of 'mmyyyy' and the query is sorted by the date field. I want the format in the report to be "mmmmyyyy'. How do I write the format statement?