Maximum of two tables

[Guest]

I have two tables which each have data about the mileages of 10 different
vehicles. I am trying to use a query to find the highest mileage result in
either table for each of the ten vehicles.

Should i be using the MAX function or DMax function?

Any suggestions of what the formula should be?

Thank you

 

[John Vinson]

I have two tables which each have data about the mileages of 10 different
vehicles. I am trying to use a query to find the highest mileage result in
either table for each of the ten vehicles.

Should i be using the MAX function or DMax function?

Any suggestions of what the formula should be?

Thank you

What are these two tables? How do they differ? It sounds like you may
have a flawed design if you have the same basic kind of information
(milage for vehicles) stored separately in two tables...

There's not enough information to give you a good answer. You may need
a UNION query (to essentially string the two tables together into one
larger table), and use a Totals query with the Max function; you may
need to use two DMax() expressions, one on each table, and an IIF()
function to determine which maximum is bigger... it depends on the
context and how you want to use the result.

More info please!

John W. Vinson[MVP]