hello i have a query that prints out these results (pic attached). I want the query to display another column that shows how many times a row appears for that month. Fro example, you can see that there are 4 rows that appear in december. so the new column should show a "4" on all of the 4 rows for that month. can this be done? thanks
here is my code:
SELECT tblHHFRequest_Main.[Channel ID], tblHHFRequest_Main.Serial, tblHHFRequest_Main.[Date Requested], tblHHFRequest_Main.[Due Date], tblCustomerMaster.SIC, tblRecorderMaster_ALL1.DeviceType
FROM tblCustomerMaster INNER JOIN (tblHHFRequest_Main INNER JOIN tblRecorderMaster_ALL1 ON tblHHFRequest_Main.[Channel ID] = tblRecorderMaster_ALL1.RecorderID) ON tblCustomerMaster.CustomerID = tblHHFRequest_Main.[Channel ID]
WHERE (((tblHHFRequest_Main.[Due Date]) Between #1/1/2011# And Date()) AND ((tblCustomerMaster.SIC) Like "*ABS*") AND ((tblRecorderMaster_ALL1.DeviceType) Like "*skytel*"));