Dec 14 2005, 07:57 AM
I have got Total sale and Date controls. Date has got 1/Feb/2005 format.
My question is how can I make a query which will group by month such as
etc etc. ?
Dec 14 2005, 08:01 AM
Date and Month are reserved word in Access and should not be used as object names. Also avoid spaces and special characters in object names.
Select Sum(TotalSale) as Total, Format(YourDate,"mmm") as YourMonth
Group By Format(YourDate,"mmm")