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.
 
Back
Top