Hi, Is there something wrong wit

[sanjs]

Hi,

Is there something wrong with this query?

SELECT TOP 10 appold.`Cost Code`, SUM((appold.`Data Units` + (appold.`Voice Units` + (appold.`Data Faults` + (appold.`Voice Faults` + (appold.Telephone + appold.Survey)))))) AS Sums FROM appold GROUP BY appold.`Cost Code` ORDER BY SUM((appold.`Data Units` + (appold.`Voice Units` + (appold.`Data Faults` + (appold.`Voice Faults` + (appold.Telephone + appold.Survey)))))) DESC

I get an error:

Error(-2147217900):[Microsoft][ODBC Microsft Access Driver] Syntax error (missing operator) in query expression...

Regards,

Sanjay

 

[r937]

try it without the MySQL backticks


rudy

 

[sanjs]

Thans Rudy,

But no joy it still reports that error.

Regards,

Sanjay

 

[r937]

uh, sorry, i see you have some spaces in your column names

replace the backticks with square brackets:

select top 10
[Cost Code]
, sum( [Data Units]
+ [Voice Units]
+ [Data Faults]
+ [Voice Faults]
+ Telephone
+ Survey ) as Sums
from appold
group by [Cost Code]
order by sum( [Data Units]
+ [Voice Units]
+ [Data Faults]
+ [Voice Faults]
+ Telephone
+ Survey ) desc

 

[sanjs]

Thanks r937,

But it still complains with the error - what the hell's wrong?

Sanjay

 

[r937]

is this a pass-through query?

otherwise, i think the syntax is okay for access

you might want to ask on the access forum

 

[sanjs]

Yes - I think, I use it in Dreamweaver and its fine, but I need it in another package that creates on-the-fly charts, which is where the error occurs. I contacted the product manufacturers and they say its an error in the sql - maybe they're wrong?

Regards,

Sanjay