SELECT TOP

[Ray Hogan]

Hi,
Please advise how I can get the following to select the value in
cboCategoryPrize in the following statement;
SELECT TOP Me! [cboCateroryPrize] qryWinner.CreScrPrize,
qryWinner.TotalPts, qryWinner.CreScrHCap, qryWinner.Back9
FROM qryWinner
WHERE (((qryWinner.CreScrHCap)<[Forms]![frmCriteria]![txtLessThan]))
ORDER BY qryWinner.TotalPts DESC , qryWinner.Back9 DESC;
This give me a Reserved word or argument name misspelled or missing
response.
Thanking you in anticipation.
RayH

 

[Douglas J. Steele]

I don't believe what you're trying to do is possible: the only place you can
refer to external values is in the WHERE clause.

You'll have to dynamically rewrite the SQL each time.