I have this query running in a report but what im trying to do is have one column showing the grouped results under one heading for each, the next column showing how many of that heading its found and the third showing from those results how many has a field with a 2 character code documented.
SELECT workflow.Source, Count(workflow.Source) AS NoContactsBySource
WHERE (((workflow.[Preferred Contact Date]) Between [Enter Start Date] And [Enter End Date]))
GROUP BY workflow.Source;
so it should look like this
Internet 3 1
Telephone 4 3
Face to Face 2 0
Ive got the first two columns sorted but i need it to find out from those results in the first 2 columns how many have actually been completed, we document the completed records by entering initials of the person who did it.