Sebastian Mendel schrieb:
> Neil Tompkins schrieb:
>> Hi
>>
>> I want to order by the totalled fields varProductCount and
>> Products.ProductReviewDESC
>
> just put them together, separated with comma, like it is written in the
> manual
>
> ORDER BY varProductCount + Products.ProductReviewDESC,
> COUNT(ProductsPurchases.ProductID)
>

sorry:

ORDER BY COUNT(ProductsPurchases.ProductID) + Products.ProductReviewDESC

--
Sebastian