Tried =Format([Date-Entered By Month],"mmmmyyyy")Sounds like "mmmmyyyy" would work, have you tried it? What happened?
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?
This worked for me.Tried =Format([Date-Entered By Month],"mmmmyyyy")
Received error #Type!
?format(date(),"mmmmyyyy")Can you provide an example of a value formatted that way: "mmmmyyyy"?
Look At the Monthly Query, it is in the correct order but I cannot get the report in the same order.?format(date(),"mmmmyyyy")
August2022
?format(date(),"mmmyyyy")
Aug2022
?format(date(),"mmyyyy")
082022
I was hoping the OP would explain what the desired output would look like. I already KNOW what Access produces.?format(date(),"mmmmyyyy")
August2022
?format(date(),"mmmyyyy")
Aug2022
?format(date(),"mmyyyy")
082022