Solved

need to create a criteria to filter by max value in query select

Posted on 2010-11-20
3
706 Views
Last Modified: 2012-08-14
I tried using the max function but it's returning all the records screenshot
0
Comment
Question by:solarisinfosys
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
ID: 34182069
You can use TOP 1 Query expression for that purpose. Below link will guide you how to do it.

http://www.blueclaw-db.com/accessquerysql/select_top.htm

Sincerely,
Ed
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34182077

I used the same expression with some of my applications and it worked perfectly. Here's a sample sql statement on it:

SELECT Top 1 Location.LocationID, Location.State, Location.City
FROM Location
ORDER BY Location.LocationID DESC;

The result display the Max value of  LocationID with its corresponding records.

Sincerely,
Ed

0
 

Author Closing Comment

by:solarisinfosys
ID: 34185307
Thanks, it worked perfectly. Thanks for the example
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Outlook Macro to delete emails not meeting keywords 56 118
Combo box with two columns question 7 40
View SQL Count Records 3 32
Access 2010 Report Not Reading Data 19 23
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

752 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