Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
MS Access Query to Order By Month Names
I am Using the Format Function to retrieve Month Name (If I use MonthName(Month(date)) Function The Query is Executing at Access DB(but when I am trying to Use the Same Query from My Application I am getting Errors
My Query is
SELECT Format(date ,"mmmm") as MonthName,
Sum(Rojnamchatable.asal1) AS SumOfasal1,
Sum(Rojnamchatable.chaat1) AS SumOfchaat1,
SumOfasal1 SumOfchaat1 AS TotalBiri1,
Sum(Rojnamchatable.asal2) AS SumOfasal2,
Sum(Rojnamchatable.chaat2) AS SumOfchaat2,
SumOfasal2 SumOfchaat2 AS TotalBiri2,
GROUP BY Format(date ,"mmmm")
ORDER BY Format(date ,"mmmm")
I am Getting Data Perfectly But I am unable to get Order By Month Name
(i.e Jan ,Feb ,March)
I Even Used Format(date,"mm") Function If I Use that I am getting Errors
So Please try to Solve My Issue
I Spent 2 days for this