Question Help. Arranging Monthname in a query...

shieriel

Registered User.
Local time
Tomorrow, 04:17
Joined
Feb 25, 2010
Messages
116
I created a query with monthly performance. The problem is the arrangement for monthname is alphabetical so the first became the month of April considering its first letter. How can i make it arrange that January is the first and so on....
 
Send a short example of your MDB, (Access 2000 or 2002-2003, ziped).
 
The quickest and easiest way to do this is to go the properties of the column months and insert the headings manually

"Jan";"Feb";"etc"
 

Users who are viewing this thread

Back
Top Bottom