Solved

Access - Select record # in Query

Posted on 2011-03-07
4
234 Views
Last Modified: 2012-05-11
Hi,

Is there a way in Query Design View, I can select only the first 1 - 50,000 of 100,000 records to be displayed? (perhaps in the 'Criteria' section).

Thanks
0
Comment
Question by:tahirih
  • 3
4 Comments
 
LVL 74

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 35059113
I'm not sure about the Designer, but you could open up SQL view and add "top 50000" to your query.

Example:
SELECT TOP 50000 *
FROM tblName

Open in new window

0
 

Author Comment

by:tahirih
ID: 35059227
I am adding other parameters to this query, but simplified it for the posting of the question.

Please find the SQL statement as follows:

SELECT [I10-I9 Dx Gem].[ICD-10 Dx Code], Count([I10-I9 Dx Gem].[ICD-10 Dx Code]) AS [CountOfICD-10 Dx Code]
FROM [I10-I9 Dx Gem]
GROUP BY [I10-I9 Dx Gem].[ICD-10 Dx Code];

0
 

Author Comment

by:tahirih
ID: 35059248
The following worked:

SELECT TOP 50000 [I10-I9 Dx Gem].[ICD-10 Dx Code], Count([I10-I9 Dx Gem].[ICD-10 Dx Code]) AS [CountOfICD-10 Dx Code]
FROM [I10-I9 Dx Gem]
GROUP BY [I10-I9 Dx Gem].[ICD-10 Dx Code];


0
 

Author Comment

by:tahirih
ID: 35059251
Please confirm what the statement would be for the remaining, > 50000

Thank you
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

757 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

19 Experts available now in Live!

Get 1:1 Help Now