I have tried the suggestions.  I tried adding the brackets as Wayne suggested.  I also tried adding the option of using SQL compatible syntax and that did not work either.

They...

I'm using Access as a back-end to a website so a pass through query is out of the question.  I decided that for now I'm just going to have 2...

It says Join Expression Not Supported when I add the part in italics.

I investigated the bracket problems and I'm closer, but still not there yet:

This Clause works:

FROM (((oitems

    INNER JOIN orders ON oitems.orderid = orders.orderID)

    INNER JOIN...