SELECT TOP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray Hogan - 25 Mar 2005 11:18 GMT

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

Reply to this Message

Douglas J. Steele - 26 Mar 2005 12:44 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> Please advise how I can get the following to select the value in
[quoted text clipped - 8 lines]
> Thanking you in anticipation.
> RayH

Reply to this Message