> 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
correctly.
I guessed that was because AmountSold doesn't actually exist (ie it's the
result of the aggregate function). So I tried ORDER BY
SUM(PurchaseItem.Quantity) but that doesn't work either (hence resorting to
sorting the query after the event).
As for ShopUID and Status, that just limits the query to completed orders
(Status = 2) and the website the orders are related to (ShopUID).
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------
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.
