Link to home
Start Free TrialLog in
Avatar of rgvn
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
Avatar of will_scarlet7
will_scarlet7

I think you would do it like this:

SELECT Max(price1) AS Max1, Max(price2) AS Max2 , Max(price3) AS Max3 FROM table1
Avatar of peter57r
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
ASKER CERTIFIED SOLUTION
Avatar of will_scarlet7
will_scarlet7

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Shouldn't the answer have been credited to Pete?