Selecting ICITEM.DESC 1

[johnny45]

Hello I'm using the following to select from pervasive Accpacc DB:

SELECT ICITMV.ITEMNO, ICITMV.VENDCOST, ICITEM.DESC
FROM ICITMV INNER JOIN ICITEM ON ICITMV.ITEMNO = ICITEM.ITEMNO
WHERE (((ICITMV.ITEMNO)='101553'))
GROUP BY ICITMV.ITEMNO, ICITMV.VENDCOST, ICITEM.DESC
HAVING (((Count(1))=1))

however DESC is a reserved word in pervasive, I must use "ICITEM.DESC"...but if I use "ICITEM.DESC" iI get automation error from excel VBA which is using this query...

Any help would be apreciated

 

[johnny45]

GOT IT....

"ICITEM.DESC" SHOULD BE:
ICITEM."DESC" ==> works !!!!

 

[ettienne]

or ICITEM.[DESC]