Continuation - Past Due (30, 60, or 90)

[dgaletar]

OK, so I lied! Sue me. lol There was really little chance that that last question was really going to be my "last" one on this topic!!! It's going too well.

The query worked perfectly, as expected!

The problem now is that each vehicle has MANY services, and therefore the report is returning all of them that are more than 30+ days old. 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, as of 2/14/13, it is current.
• truck #2 was serviced on 1/1/12 and 6/1/12 only.
• Therefore, as of 2/14/2013, truck #2 is over 90 days past due, and should thus appear on the report.
  
  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.

Does this make sense???

(BTW, I learned last time to let everyone know that I also have this question going in another Access Forum, here. Feel free to jump in on either one. Thanks!)

[pbaldy]

You can use this technique:

http://www.baldyweb.com/LastValue.htm

or perhaps DMax() to get the last service.

[dgaletar]

OK, now you are just freakin me out, Paul!!! Did you seriously just write that article for me???

Either way, you are the best! Thanks!!!

[pbaldy]

LOL! Happy to help.