The Crosstab Query Wizard works with only one table at a time. If you need to create a query with fields from more than one table, first create a select query that includes the necessary fields ...

Squash the dangers lurking in your SQL queries by setting parameters by way of parameterized queries.