Solved

MS Access Query--Display only first (top) record set

Posted on 2014-09-14
2
595 Views
Last Modified: 2014-09-14
Experts:

I have an Access Query ("Querry1").  Record-sets within this Query are automatically sorted by the 'Last Field that was Modified' so the Record-set containing the last field that was updated will always appear first (at the top) in my Query.
I only want the Query to display this first (top) Record-set (I do not want any other Record-sets to be displayed).  Does anyone have an idea how to do this?

I'm not great with Access, so if you could walk me though each step it would be most appreciated.

Thanks.
0
Comment
Question by:mdstalla
2 Comments
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
Comment Utility
You need to use TOP 1 clause in the query. Let's assume your query has this syntax:
SELECT column1, column2, LastModifiedDate
FROM Table1
ORDER BY LastModifiedDate DESC

Open in new window

When you add the TOP 1 clause the query will look like:
SELECT TOP 1 column1, column2, LastModifiedDate
FROM Table1
ORDER BY LastModifiedDate DESC

Open in new window

0
 

Author Closing Comment

by:mdstalla
Comment Utility
Ha!  How easy was that!

Thanks for your help C!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now