Query Too Complex But it is pretty simple.

[Phil Smith]

I have the following query. It is based on Sales Freight Breakdown
Complete, a query which runs just fine, no problem.


All this does is sort and sum the results of that query. This was
working fine, now for some reason, (upgrading to office 2007), I get
this error.

Any Ideas?

Phil





SELECT [Sales Freight Breakdown Complete].Account, [Sales Freight
Breakdown Complete].Division, [Sales Freight Breakdown
Complete].Department, [Sales Freight Breakdown Complete].Category,
[Sales Freight Breakdown Complete].Warehouse, [Sales Freight Breakdown
Complete].Brand, [Sales Freight Breakdown Complete].Memo, Sum([Sales
Freight Breakdown Complete].ship_cost) AS SumOfship_cost
FROM [Sales Freight Breakdown Complete]
GROUP BY [Sales Freight Breakdown Complete].Account, [Sales Freight
Breakdown Complete].Division, [Sales Freight Breakdown
Complete].Department, [Sales Freight Breakdown Complete].Category,
[Sales Freight Breakdown Complete].Warehouse, [Sales Freight Breakdown
Complete].Brand, [Sales Freight Breakdown Complete].Memo
ORDER BY [Sales Freight Breakdown Complete].Account, [Sales Freight
Breakdown Complete].Division, [Sales Freight Breakdown
Complete].Department, [Sales Freight Breakdown Complete].Category,
[Sales Freight Breakdown Complete].Warehouse, [Sales Freight Breakdown
Complete].Brand, [Sales Freight Breakdown Complete].Memo;

 

[Jeff Boyce]

Phil

What happens if you "back off" from the full version by eliminating one of
the complexities? For example, if you remove the aggregation
(Totals/GroupBy), does it run?

If this were mine, I'd create a new query (they sometimes get subtly munged)
and keep adding pieces/complexity until it either worked or broke, at which
point I'd know better what was breaking it.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP