SELECT TOP X - Can that be variable?

[rubbernilly]

I'd like to provide some flexibility to the query, to where the user could decide to pull the TOP 5, TOP 3, TOP 20, whatever.

Using a parameter does not work:

SELECT TOP [Enter Value]...

I figure I can do this by manipulating the SQL of the querydef, but I'd like to just have some straightforward flexibility rather than a lot of backend programming.

Possible?

 

[TheAceMan1]

How are ya rubbernilly . . .

I havn't tested parameters in this case, but if it doesn't work, go the VBA route and concatenate an [blue]InputBox[/blue] into the SQL!

See Ya! . . . . . .