Calculate min value from multiple fields for one record in Access 2003
Posted on 2007-04-10
I thought this would be an easy task, but need to ask for help. I need to calculate minimum value of multiple fields for one record (one record has multiple contract terms and I need to calculate the minimum in a query in order to report on it). In Excel I would just use =MIN(field1, field1, field3), but apparently the MIN function in Access/SQL finds the minimum of multiple records within one field.
How do I compare fields within one record to find the minimum in Access?