To include fields from more than one table, create a query containing all the fields you need and then use this query to make the crosstab query.

• 如要包含多个表中的字段，请创建一个含有所需全部字段的查询，然后用这个查询创建交叉表查询。