counting unique entries

[Pastor Del]

I have 2 linked tables, tblPN & tblReceivedDate. tblPN has field PN and tblReceivedDate has field [Received Date]. The tables are used to record the receipt of different part numbers and the date they received. I want to use a query to count how many times a part number is received. The catch is that I only want to count a part once even if it is received more than once on the same date. With the data in the attached DB the count for PN 123 would be 5.



Can someone show me how to configure the query to do what I need to do?

[June7]

Try:

Query1
SELECT tblPN.PN, tblReceivedDate.[Received Date]
FROM tblPN LEFT JOIN tblReceivedDate ON tblPN.PN_ID = tblReceivedDate.PN_ID
GROUP BY tblPN.PN, tblReceivedDate.[Received Date];

Query2
SELECT Query1.PN, Count(Query1.[Received Date]) AS [CountOfReceived Date]
FROM Query1
GROUP BY Query1.PN;

All in one:
SELECT Query1.PN, Count(Query1.[Received Date]) AS [CountOfReceived Date]
FROM (SELECT tblPN.PN, tblReceivedDate.[Received Date]
FROM tblPN LEFT JOIN tblReceivedDate ON tblPN.PN_ID = tblReceivedDate.PN_ID
GROUP BY tblPN.PN, tblReceivedDate.[Received Date]) AS Query1
GROUP BY Query1.PN;

[Pastor Del]

I'm wondering if there is a way to get the count using DCount.

[June7]

Could use DCount referencing Query1.