Setting the month format in a quert

[Guest]

I have a query with two columes

WagesDate:Format([Date],"m") WagesAmount

Wages Table
Group By Sum


This gives me a monthly total of wages.
8 £21,000
9 £27,000


The months are displayed in numbers (eg 8 for August) the problem is when
the year changes the months will combine eg august 2005 will combine with
august 2006. Is there any way of adding the year to the month so that i get
seperate months for each year or can i just dispay the date in normal format
21 August 2005 and remove the numbers form the date to give me August 2005

 

[Nikos Yannacopoulos]

Try:

WagesDate:Format([Date],"yyyy/mm")

HTH,
Nikos

 

[Guest]

Or you can have to seperate fields for the year and the month

Select Year([Date]) as YearOfDate , month([Date]) as MonthOfDate From
TableName OrderBy Year([Date]) , month([Date])

incase you still want to display the month as a seperate field