Hi Richard, I have a few questions about this lesson: 1)Is a CrossTab Query like a Pivot Table (in Excel)? 2)If you had multiple Tables in your query, would you have to specify the "TABLE.fieldname" in the WHERE condition too? 3)For Operator Precedence, why doesn't NOT evaluate before AND/OR? - Isn't it kind of like a Comparison Operator, in that it also applies to just 1 field - while AND/OR applies across multiple conditions to multiple fields at the end? Thank you very much for your help.

---

Reply from Alex Hedley:

1) You don't have the same power as a Pivot Table since you don't have the drag in columns, filters etc. Think they removed Pivot Tables from Access 2013 (Discontinued features)

2) Yes you would have to be specific about your WHERE clause, just alias your Tables and add them there.

3) MS Article