Find the minimum value across many columns.

  • Thread starter Thread starter MJ McMullen
  • Start date Start date
M

MJ McMullen

I have built a query where each record has 6 columns of
data. What I would like to do is through the query, find
the minimum value across those columns. Is there an easy
way to do this in Access? It's easy in Excel but I want to
avoid export and importing if at all possible. Any help
would be appreciated.
 
Access doesn't work well with data across columns, (it's better with rows),
and unless your handy with a little VBA, the export may be easier for you.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
It sounds like your data is already organized like a spreadsheet -- is there
a (business) reason why you are using Access instead of Excel?
 
Back
Top