Good Afternoon,
Can you tell me how to have the "Count" function in a query only display unique count?
i.e. - I want to count total "Loads" per "Department", trouble is that "Department" is only referenced in the "LoadDetails" table....
LoadID - 19, Department - Surgery, Instrument - Clamp, Qty - 2
LoadID - 19, Department - Surgery, Instrument - Scissors, Qty - 4
etc...
I want the query to count the above as 1 Load for Surgery on specified date.
Thanks for any help!