Thanks! Changing the parenthesis worked perfectly! Unfortunately, I couldnt get the builder to work the way I needed it to with the multiple joins, but it's probably my lack of experience using the Access builder.
I've created a query to bring in all of P table and any associated E data from another table where available. Running the query using a single join works fine. Once I add in the additional join(s) I get a syntax error and after searching and searching I havent been able to determine where the...