Count Records

[Newbie11]

I am working on a database that is tracking employees, the part numbers they have ordered, and if they have been shipped/backordered.

I have a report 'qryOrderShipmentPart' that shows the Order and Shippment details for the part selected in the form 'Filter' within the specified dates. For the sake of my testing I have been working with Part #9009.



The report works just fine there is just one more count I would like the report to display - how many of those specific parts have been ordered. That is, I can see how many parts have been shipped/backordered for Part #9009 but I would also like to see how many orders there are total for Part #9009 within the specified dates so I can calculate a shippment percentage. So far I can't get this to work. HELP...PLEASE.

[June7]

The lookup set in table caused me a little trouble but finally recognized the value of Status was really a number and not text. I never set lookups in tables.

Use this expression for Shipped: Count(IIf([Status]=1,[Status]))
The expression for Ordered: Count(*)