Turning dates into months - help!

[Johnrg]

Guys,

I have a query that list records under the following three simple feilds

Date Required, Currency, Total Price

I want to get another query to sum these records into:

Month Required
Currency (grouped togeather under each month)
Total Price (Summed in each month above)

I am stuck on how to turn individual dates into a month grouping.

Anyone help?

Thanks
JohnG

 

[vbaInet]

Investigate the Month() and MonthName() functions. Or look into the Format() function.

Here's a good site for these functions:

http://www.techonthenet.com/access/functions/index_alpha.php

 

[KitKatePuzzle]

Type this in selection query
Temp: month(Date Required)