Horizontal grouping

[John]

Hi

I need to "group" figures by month. I only need the totals for each month so
detail is not required. My problem is that I need the months to appear
horizontally and each month's figure underneath it. Here is the example;

Jan Feb Mar ...... Dec
£2345.00 £1626.00 £9484.00 £23939.00

How can I achieve this?

Thanks

Regards

 

[Phil Hunt]

Have you tried the crosstab wizard under the new Query tab.

 

[Duane Hookom]

You can create this with a multi-column layout.

 

[pietlinden]

crosstab query