See http://www.mail-archive.com/[email protected]/msg14920.html for
sorting queries
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 28, 2000 11:55 AM
To: 'DeVoil, Nick'; CF-Talk (E-mail)
Subject: RE: Desperately need help - sorting a QueryNew()
> There's no reason why you shouldn't be able to get it sorted
> by the original
> query.
> Did you try "ORDER BY AmountSold" or "ORDER BY 2"?
> What table(s) are Status and ShopUID on? What does Status=2 mean?
AmountSold is a calculated column, created by:
SUM(PurchaseItem.Quantity) AS AmountSold
I've tried doing ORDER BY AmountSold but it just says
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
