Count fields

[hithere]

I have a report souced from a criteria query. The user must enter the order date and all orders occuring on/after that day will appear in the report. What I would like to have included at the top of the report are counts for 1) how many orders there are 2) how man orders have been shipped and 3) how many orders have been backordered. This number will change each time the report is run to reflect the records that match the critieria. Is there any way that I can accomplish this? I'm not sure if I need code or a query. I've attached the db for analysis. Thanks.

[June7]

Try the following expressions as textbox ControlSource

=Sum(IIf([Status]=1,1,0))

=Sum(IIf([Status]=2,1,0))

[hithere]

Thank you! These work great. I was struggling with DCount functions. Is there any way to count how many orders total appear in the report and possibly provide percentages for the shipped/backordered fields? I.E. based on the criteria there were 10 orders- 5 shipped, 2 backordered. Shipped % = 50% and Backordered % = 20%

[June7]

You already have the total order count with the expression: =Count("*")

Now in other textboxes have expression that divides the Shipped by Count and BO by Count:
=tbxShipped/tbxCount
=tbxBO/tbxCount

Can set the Format property to Percent or in the expressions: * 100

[hithere]

Thanks. There's so much info I could pull from this report. I tried inserting a =count(isnull(OSID)) to count all the orders that doing have any shipping info but it gives back the same result as Count("*").

[June7]

Try:

=Sum(IIf(IsNull(OSID),1,0))

[hithere]

THANKS!! That did the trick. Just for curosity, why didn't =Count(isnull(OSID)) work?

[June7]

The IsNull() function will return a value of True or False and the Count will count all returns, regardless of what it is except for Null. Null is ignored by aggregate functions. Try: Count(IIf(IsNull([OSID]),1,Null))