Solved

max(field1,field2) from a table

Posted on 2004-10-08
4
260 Views
Last Modified: 2010-08-05
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
0
Comment
Question by:rgvn
  • 3
4 Comments
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12257117
I think you would do it like this:

SELECT Max(price1) AS Max1, Max(price2) AS Max2 , Max(price3) AS Max3 FROM table1
0
 
LVL 77

Expert Comment

by:peter57r
ID: 12257160
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
0
 
LVL 15

Accepted Solution

by:
will_scarlet7 earned 50 total points
ID: 12257213
Sorry, I though you were trying to get the max of each field. If you want the max between the three then Pete's solution is the right way to go.

Sam
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12257373
Shouldn't the answer have been credited to Pete?
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question