Ed Reed wrote:
Thanks Jeff,
After a little more investigation it turns out that the problem only
exists when I run the query through a MS Access database attached to
MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs
just fine.
Any ideas for a work around?
- Ed
Use an Access
Thanks Jeff,
After a little more investigation it turns out that the problem only
exists when I run the query through a MS Access database attached to
MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs
just fine.
Any ideas for a work around?
- Ed
>>> <[EMAIL PROTECTED]> 3/2
>Is there any way to do the following? I get an error whenever I try this
>(Invalid use of Group function).
>Select Product, Sum(Qty)
>From Inventory
>Group By Product
>Order By Sum(Qty) DESC;
This should work if you assign it an alias...it does for me on 4.018(not
exact query)
S
