Max value for record

[rob.lyles]

Hi, I'm using a query to apply branch cost to a customer contract by part number. A record consist of a part number, description, and branch cost fields ranging from 3 or more. For that record or part number, I would like to display the highest branch cost perhaps as the last field in that record. Is this possible?

Thanks

 

[John Big Booty]

Check out the Dmax() function, you should be able to use that to return the value you are looking for.