Software

Ask something
Discussion Locked

Need Access Report Help

0 helpful
6 replies

by mitchbryant

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to "count" at the end of a report certain ranges... We "aged" an item based on [AgedDate]... So I want to do a 1-30, 30-60 etc... Count of how many items are within those ranges...

I know how to use the normal Count command but not how to count just a specific range within a larger report..

Can anyone help ????

6 replies

by dklippert

CountIf doesn't work in Access. Try this combination:

0-30:IIF([AgedDate] <= 30, 1,0)
30-60:IIF([AgedDate] > 30 and Value <60, 1,0)
60-Plus:IIF([AgedDate] >= 60, 1,0)

=sum([0-30])
=sum([30-60])
=sum([60-Plus])

by mitchbryant

I am not sure how to apply your suggestion. I normally use a field in the footer... Can you help ???

by spongebob_squarepants

Create a text box for each range, using the formula builder in the properties for each box, enter the specific part of the formula (from the previous response) that is applicable for each range.

This discussion is closed to new replies.