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 ...

Though pivot tables allow Excel users to quickly sort data into a useful crosstab format, some users may feel intimidated by the tool's apparent complexity. Danny Rocks, owner of the software ...