Hi guys,
Ok well i've got a query with how long it takes to get specialist diabetes appointments in weeks as shown in the attachment with the datasheet and design views of the query.
here we have the SQL coding:
SELECT [Time taken].Month, [Time taken].ArrivalDate, [Time taken].AppointmentDate, [Time taken].[Time Taken], [Time taken]![Time Taken]/7-0.4 AS [Time in weeks]
FROM [Time taken]
WHERE ((([Time taken].Month)=#5/1/2010#))
ORDER BY [Time taken].Month, [Time taken].[Time Taken];
Now what i'd love to be able to do is group the number of appointments that are are seen in each week to give a total. For example, if there were 2 appointments seen within 1 week, another 3 appointments within the second week then it'd would be great if the query could show this.. ideally with the total number of patients seen each week within weeks 1-8 then with a total number of patients seen after 8 weeks i.e. 8 week plus total, with the weeks as headings so something like...
week1 week2 week3 week4 week5 week6 week7 week8 week8+
1......... 2........ 3....... 5...... 2....... 1....... 2....... 3....... 20
(the dots are only there because it kept bunching the numbers at one end for some reason)
Pretty lost on this so any help would be great!!!
Thanks!!
Katie x