Re: Query for MAX value
First, I only used "Name" in the example. It's not the real name of the field.
Your solution worked great. But now on to Part 2.
The values in the "DriveID" field are always odd and always increase by two.
What I need is 4 separate queries for the 4 highest values in the "DriveID" field.
Can your solution be modified to accomplish that.