• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Access - Select record # in Query

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
tahirih
Asked:
tahirih
  • 3
1 Solution
 
käµfm³d 👽Commented:
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
 
tahirihAuthor Commented:
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
 
tahirihAuthor Commented:
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
 
tahirihAuthor Commented:
Please confirm what the statement would be for the remaining, > 50000

Thank you
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now