Hello. I think that this is going to be a pretty easy one, so here it goes.
I have a report that, when generated, supplies a list of all of the vehicles that have not been serviced for 30 to 59 days, 60 to 89 days, and over 90 days.
The problem is that each vehicle has MANY services. I just need to show FROM the last service date to today if it's past due.
Here is an example:
Everything on the form is working fine except for this feature.
Thanks all!
I have a report that, when generated, supplies a list of all of the vehicles that have not been serviced for 30 to 59 days, 60 to 89 days, and over 90 days.
The problem is that each vehicle has MANY services. I just need to show FROM the last service date to today if it's past due.
Here is an example:
- truck #1 was serviced on 1/1/12, 6/1/12, and 1/1/13. Therefore it is current.
- truck #2 was serviced on 1/1/12 and 6/1/12 only.
- Therefore truck #2 is over 90 days past due.
As of right now on my report, ALL 5 services are showing up. What I'm looking for is ONLY truck #2, (with it's last service date of 6/1/12) to show up.
Everything on the form is working fine except for this feature.
Thanks all!