Comparing Calculated Fields and returning the Max Number

[Guest]

I have several (6) calculated fields in a query...I would like to compare these fields and return the highest number from the different fields in a new calculated field. Any help would be greatly appreciated.

 

[Rebecca Riordan]

To the best of my knowledge, you can't do this directly with SQL. What
you'll need to do is write a little VBA function that accepts the six values
as arguments returns the largest.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I have several (6) calculated fields in a query...I would like to compare

these fields and return the highest number from the different fields in a
new calculated field. Any help would be greatly appreciated.