SELECT TOP

  • Thread starter Thread starter Ray Hogan
  • Start date Start date
R

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
 
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.
 
Back
Top