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...
JeffSawyer said:
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.
