Find the minimum value across many columns.

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.
 
M

[MVP] S.Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
J

Jeff Boyce

It sounds like your data is already organized like a spreadsheet -- is there
a (business) reason why you are using Access instead of Excel?
 
Top