Grouping By Month

[matthoward]

Could anyone tell me how I can break a years worth of daily transactions down to a month by month grouping? For example

1/1/3 $4000
1/1/3 $6
15/1/3 $50
20/2/3 $560
28/2/3 $10
2/3/3 $57
23/3/3 $67

So I would have a grouping of
Jan 4056 dollars
Feb 570 dollars
March 114 dollars

Help as always is greatly appreciated,

Cheers

 

[Reebo99]

Insert > Group choose the date field, then choose for each month.

Then right click on the amount field, insert > summary > sum, and choose then group you've just created.

suppress then detail section.

Let me know how you get on......

Reebo
Scotland (Sunny with a Smile)

 

[matthoward]

thank you for ya help it worked perfectly.

Cheers