Question Sum if

[jamil_786]

Dear Freind,
I have a report with following format

(Age)($Amount)
90 100.00
90 200.00
60 100.00
30 200.00
14 500.00
10 700.00

I want to see the following result in report footer in that way
Amount Count
60 to 90 400 3
30 to 59 200 1
<15 1200 1

 

[KenHigg]

One way would be to use dcount()

 

[jamil_786]

Thanks Ken.

I tried DSum and DCount but there is msg showing with error. I wrote this

=DSum([AGE (DAYS)]>30,[$ AMOUNT]))

=DCount([AGE (DAYS)]>30,[$ AMOUNT]))

 

[KenHigg]

Use Access help and see how you have the syntax wrong.