I am trying to get a count of all the tests due in certain years.
I have 4 tests:
Service Due
Lining Due
Qualification Due
Valve due
I have a bunch of cars that need these tests done at different times. I want to be able to see a count of how many cars need each test done in the next 5 years.
So kind of like this
Code:
2023 2024 2026 2027 2028
Service Due 23 15 34 21 12
Lining Due 15 34 18 55 17
Qualification Due 45 74 34 23 33
Valve due 34 23 12 23 55
I have checked out a crosstab query but that does not seem to work for me. I have tried a basic query using dates and or but that doesn't work either. It seems like I am going to have to make a separate query for each test AND date rage and find a way to put them together and that would mean 12 queries.
I am sure there is a more efficient way someone can think of to do this.
Thanks