Trouble Finding "Oldest" Data

[bigdan5428]

I will try my best to describe my situation. I have a table with 4 colums: Date, Equipment, x, and y. "X and Y" don't matter for this problem. The table is a history of a certain part change for each piece of equipment. What I am wanting to do is look at each equipment name (there are 12 at this time) and find the most recent date for the part change on each. Given that information, I want to calculate which of those values is the oldest. Basically, given the history, I'm wanting to know which piece of equipment has had the longest amount of time go by without the part change. Any help to lead me in the right direction would be appreciated.

[pbaldy]

The first query here should find the most recent for each:

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

You can add the DateDiff() and Date() functions on the result to find the oldest.

[bigdan5428]

SQL for first query works exactly as I wanted! Thank You! After looking at the 2nd part of the page, I was interested to try that as well. I am unfamiliar with the "INNER JOIN" command. I get an syntax error in the JOIN function. I changed all your table names, fields, queries to match my application but I still am getting a snytax error in the JOIN function.

[pbaldy]

Hard to say without seeing your query.

[bigdan5428]

Must have had a comma in the wrong place or something, tried it again from scratch, working this time. Thanks so much for your help!!

[pbaldy]

Happy to help!