Need Minimum of multiple columns in Access Queries

  • Thread starter Thread starter Ker
  • Start date Start date
K

Ker

Each record in my access has 5 dates, loading start, travel start, etc.
I am using a query and I need to know the min of 5 columns.
Min(column1, column2, etc). IS there anyway to do this?

Thank you,
Ker
 
Ker

Please see response to Marty L's post re: passing multiple criteria to a
function.

Your design sounds like it could benefit from further normalization, before
attempting to find the Min(). You'll find that in a "one-to-many" table
design, your question is easily answered with a Totals query, on a single
field.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top