several fields with similar value

  • Thread starter Thread starter marie
  • Start date Start date
M

marie

Hi, I would like to know if someone can tell me how I
could find the highest value within several fields. I
know that the Max and Dmax functions can only find the
values within the same field. Thanks in advance
 
Try a UNION query e.g.
SELECT Max(columnValue)
FROM
(SELECT Max(col1) As columnValue FROM YourTable
UNION
SELECT Max(col2) FROM YourTable
UNION
SELECT Max(col3) FROM YourTable
etc)

Hope This Helps
Gerald Stanley MCSD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need null values for several fields in db 1
Dlookup with where conditions 1
increment field value 1
SELECT MAX(value) from table1 and add several associated values from table2 10
Max value 2
Specifying the DataType of a new field in a Query 2
Access 2007 - return maximum date 1
Requesting Help Ranking Sales Values..... 6

Back
Top