View Single Post
Old 11-08-2019, 11:45 AM   #4
RJW
Newly Registered User
 
Join Date: Sep 2006
Posts: 38
Thanks: 9
Thanked 0 Times in 0 Posts
RJW is on a distinguished road
Re: Query for MAX value

Thanks isladogs

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.


Thanks.


RJW
RJW is offline   Reply With Quote