Max - Multiple Fields

[Guest]

Hello, I am trying to create a formula that will find the maximum value of 4
different sample sites. I am having trouble finding the correct operator to
do so, if this is even possible. My field labels are; [LR21] [WD05] [WD24]
and [BR20]
Thanks,

 

[Duane Hookom]

Your table isn't normalized. I would use a union query and then basic SQL

==quniNormalized============
SELECT [LR21] as SampleValue, "LR21" as SampleSite
FROM tblUnnamed
UNION ALL
SELECT [WD05], "WD05"
FROM tblUnnamed
UNION ALL
SELECT [WD24], "WD24"
FROM tblUnnamed
UNION ALL
SELECT [BR20], "BR20"
FROM tblUnnamed;

Then
SELECT Max(SampleValue) as MaxSample
FROM quniNormalized;