SQL code, query, top values

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

i have this code

SELECT TOP 20 (FROM[..] as... order by...

the query returns top 20 records.

I want to make that number changeable
I already have the number in a Form that changes the value of top records.

Please help
 
The only way would be to alter the underlying SQL of the query. You can't
substitute a parameter for the number in the TOP statement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top 50% Grouped by Month 3
SELECT TOP n -- looking for assistance 12
Controlling the number of records displayed. 5
Top 20 1
Top 10 query not working 1
Query Parameter using multiple options 0
Enter Parametr Value 9
Order by Clause Causes new record to go to top of query 1

Back
Top