Parameter for Top clause in a query
Posted on 2006-11-15
Hello and thank you for reading my question.
Let's say that I have a query like this:
parameters intPercentage Integer;
SELECT TOP intPercentage Percent numGrades
ORDER BY numGrades DESC;
The problem seems to be that I can't use a parameter for this purpose.
Apart from using the QueryDef() to modify the query, is there some way to accomplish this?