I am hoping someone can help me here. I am stuck with a query in access and have tried everything i know to get the results i need but having no luck. Below is what i need!
I know people will say try the distinct function. And from my understanding is that it doesnt work with a cross tab query. You see all the data is one table. and the fields are as follows:
Period (which is the month)
Now a centre will hold a thousands of courses a year. Some will be englsih some will be maths etc. Now i need to count how many centres were used for a course each month for the year. Now this is the part where it gets tricky. If a centre has been counted for in a previous month then i dont want it counted again for that same course in that year.
Sorry i hope that makes more sense!