Table that groups, then counts instances 1

[Pete271]

Hi
I've tried looking on the forum but can't find quite what I need so I thought I'd give posting a go...

I've got an access database and I'm using CR8.5

I need to create a report that puts the gift amounts in to categories:

<£10,000
£10,000 - £49,999
£50,000 - £99,999

and so on. These will make up the rows.

I then need two columns. One to count how many gifts fit in each category and the other to show the total amount raised for gifts in that category.

I'm sure this is possible, can anyone help?

Many thanks
Peter

 

[lbass]

Insert a group on a formula like:

if {table.gift} < 10000 then "<10,000" else
if {table.gift} in 10000 to 49999 then "10,000 - 49999" else
if {table.gift} in 50000 to 99999 then "50,000 - 99999" else
">=100000"

Then insert a summary (count) on the gift ID and a summary (sum) on the gift amount at the group level. If the pounds can be other than whole number (I just don't know anything about that currency), you should use:

round({table.gift})

...in the above formula in place of {table.gift}.

-LB

 

[Pete271]

Many thanks lbass, worked a treat, exactly what i needed.

Peter