Need Minimum of multiple columns in Access Queries

[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

 

[Jeff Boyce]

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>