MAX()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
I'm trying to use the Max function and I'm having difficulty with setting
the query up.
I wanted to take the highest value from three fields for each category
(fldTax1,2 and 3).

tbl_citytax
fldSubsidiary
fldTax1
fldTax2
fldTax3

Any help? or do you need more info?
 
Tim

The Max() function works on a single field, finding the maximum value in
that column.

Your data design is appropriate for spreadsheets, but not for a relational
database.

You'll have to "roll your own" procedure/expression to calculate the maximum
of three fields.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Thanks Jeff,
I found a solution.






Jeff Boyce said:
Tim

The Max() function works on a single field, finding the maximum value in
that column.

Your data design is appropriate for spreadsheets, but not for a relational
database.

You'll have to "roll your own" procedure/expression to calculate the maximum
of three fields.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
Click to expand...
 
Back
Top