Dynamic number in a TOP clause

[cmac2210]

Is it possible to pass a number from a textbox into a TOP clause query?

 

[EraserveAP]

Sure.
If you are using vba you could change this:
"SELECT TOP 10 TABLE1.* INTO 1SAMPLE FROM TABLE1 ORDER BY TABLE1.ZIP;"


To this:
"SELECT TOP " & VariableHere & " TABLE1.* INTO 1SAMPLE FROM TABLE1 ORDER BY TABLE1.ZIP;"

"VariableHere" would be your dynamic number from your textbox.