*SOLVED*

A cross tab query acts like a pivot table. The people_type field becomes the column headers for the query and a one is in the field of the people that...