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.