Count Certain Records

[Dilly]

I have a report that ha a list of "Delivery Days", I am after a way of counting the number that are less than 3, 3 to 7 and 7 upwards can anybody help. I know how to create a count of the total number of records but cannot work out the syntax to seperate count by the three groups. If possible i do not want to create three groups but would to create three controls/ Text box's

 

[jebry]

Hi!

You can use the DCount function, set the record source to:

=DCount(&quot;[Delivery Days]&quot;, &quot;YourTableOrQuery&quot;, &quot;[Delivery Days] < 3&quot

And similar functions for the other two.

hth
Jeff Bridgham
bridgham@purdue.edu