-
Phonecalls Query
Phone calls query
I have a table that collects phonecalls by type, operator selects the particular type and the date.
This table is all check boxes, so I count by day the number per item and total.
I need this to give me all the months at the top with the count of the items below. there are 12 items to count which will be down the left side and the months accross the top. I have it by date now but need to be able to
see the months grouped accross the top and totaled once the month is over.
The first query is in the second query
qryCount
SELECT Phonecalls1.ID, Phonecalls1.CSO, Phonecalls1.SPA, Phonecalls1.COLLECTIONAGENCY, Phonecalls1.COUNSELINGCONSUMERS, Phonecalls1.COUNSELINGCREDITORS, Phonecalls1.PB, Phonecalls1.RTO, Phonecalls1.MORTGAGEBROKER, Phonecalls1.DDL, Phonecalls1.REFERRED, Phonecalls1.callDate, Phonecalls1.InternetLender, Phonecalls1.MLO, Phonecalls1.SLA, Phonecalls1.SLB, Phonecalls1.Licensing, Phonecalls1.PreciousMetal, Phonecalls1.Enteredby
FROM Phonecalls1;
QryphonecallsbyDate
SELECT qryCount.ID, qryCount.CSO, qryCount.SPA, qryCount.COLLECTIONAGENCY, qryCount.COUNSELINGCONSUMERS, qryCount.COUNSELINGCREDITORS, qryCount.PB, qryCount.RTO, qryCount.MORTGAGEBROKER, qryCount.DDL, qryCount.REFERRED, qryCount.InternetLender, qryCount.MLO, qryCount.SLA, qryCount.SLB, qryCount.Licensing, qryCount.PreciousMetal, [Report Start Date] AS ReportStartDate, [Report End Date] AS ReportEndDate, qryCount.callDate
FROM qryCount
WHERE (((qryCount.callDate) Between [Report Start Date] And [Report End Date]));
Any help please
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules