tahirih
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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];
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];
ASKER
Please confirm what the statement would be for the remaining, > 50000
Thank you
Thank you
ASKER
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];