D
djkc
I have a duplicates query counting accts for each of my branch locations. I
need for the query to say zero if the branch location has no accts to count.
Here is a copy of the SQL view of my query
SELECT First([Recency 180 days1].[Correct BranchNumber]) AS [Correct
BranchNumber Field], Count([Recency 180 days1].AcctNumber) AS NumberOfDups
FROM [Recency 180 days1]
GROUP BY [Recency 180 days1].[Correct BranchNumber];
need for the query to say zero if the branch location has no accts to count.
Here is a copy of the SQL view of my query
SELECT First([Recency 180 days1].[Correct BranchNumber]) AS [Correct
BranchNumber Field], Count([Recency 180 days1].AcctNumber) AS NumberOfDups
FROM [Recency 180 days1]
GROUP BY [Recency 180 days1].[Correct BranchNumber];