rgvn
asked on
max(field1,field2) from a table
Hi,
I need to retrieve the maximum value of three fields from an Access table from a row. How do I write my query in my ASP page. I tried retriving valu like
select max(price1,price2,prie3) from table1
which throws error as invalid argument passed. Please help me
Rags
I need to retrieve the maximum value of three fields from an Access table from a row. How do I write my query in my ASP page. I tried retriving valu like
select max(price1,price2,prie3) from table1
which throws error as invalid argument passed. Please help me
Rags
Hello rgvn,
Idon't know whether you can use iif in ASP but in a standard Jet query you would be able to do:
select iif(price1>=price2 and price1>=price3, price1, iif(price2>=price1 and price2>=price3, price2,price3)) from....
Pete
Idon't know whether you can use iif in ASP but in a standard Jet query you would be able to do:
select iif(price1>=price2 and price1>=price3, price1, iif(price2>=price1 and price2>=price3, price2,price3)) from....
Pete
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Shouldn't the answer have been credited to Pete?
SELECT Max(price1) AS Max1, Max(price2) AS Max2 , Max(price3) AS Max3 FROM table1