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?
 
You must log in or register to reply here.

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

Calculated field - Min of several columns 6
minimum of numbrs across 4 columns 1
Displaying data across columns 1
Minimum 1
Sum, Minimum and Maximum with a twist... 2
Time and Minimums 4
formula to return a max value across fields? 1
How do I add numbers across columns of a single record? 2

Back
Top