C
Coyote_Jackson
Trying to setup a query which takes into account a list of cars using reg
numbers:
1 ----
2 ----
3 ----
4 ----
5------
up to 100+ cars
each car will need to have a service within 3 months for the next 3 years.
I'm sure the services for each car will be staggered depending on their
previous service histories.
I need a query that i can possibly run daily showing that carA needs to e.g
have a service in 21 days... or 7 days... also this needs to take into
account a possibility there could be extrernal delays e.g. "driver off sick
to take car in"
I have thought about using Max(date) in someway or the other but keep ending
up withj loose ends...
numbers:
1 ----
2 ----
3 ----
4 ----
5------
up to 100+ cars
each car will need to have a service within 3 months for the next 3 years.
I'm sure the services for each car will be staggered depending on their
previous service histories.
I need a query that i can possibly run daily showing that carA needs to e.g
have a service in 21 days... or 7 days... also this needs to take into
account a possibility there could be extrernal delays e.g. "driver off sick
to take car in"
I have thought about using Max(date) in someway or the other but keep ending
up withj loose ends...