hello,

I was wondering whether it was possible to set a parameter on the top value, so the user could set the top value without going directly into the query?

Cheers

tommyflint

Well, yes, that could be done. What you can do is limited only by your ability to write the code to do it.

But the user has to do something, right?

Are you suggesting you want to write code for the user to be able to modify the query without going into the query builder? If that is what you want to do, you will need to modify the SQL property of the query def. There are plenty examples of manipulating a query def on this site and throughout the internet.

what i needed it to do is, when the user runs the query a little message box pops up and asks for the top value like you can do in the criteria using [message]???

Cheers

You won't be able to get that type of functionality. You'll have to roll your own if that's what you want.