Because you are using reserved words and the brackets tell Access not to use the reserved word but search for an object (table, field, ...) which has that name.


>Peter, the brackets works, thanks a lot.
>
>Eric, why is there a need to put the square brakets [] in your
>previous reply? I am just curious what will these [] do? Please advise,
>thanks.
>
>Once again thanks all of you who have share your professional tips.
>
>>I think some backets are needed:
>>
>>
>>SELECT StockItems.Code,StockItems.Description,StockItems.Dpt,Departments.Description,StockItemsPrc.Price FROM (StockItems INNER JOIN StockItemsPrc ON StockItems.Code = StockItemsPrc.Code)
>>INNER JOIN Departments
>>ON StockItems.Dpt = Departments.Code
>>
>>Pete