Web Development



MS Access Query to Order By Month Names

I am Unable to Sort the Order By by Month names in MS Access Database

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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums