Selection infor from columns in Crosstab query.

[survivo01]

Presently, I have 28 columns with class names. I have a query for each column to query the null cells. This tells me who has not taken the class. Is there an easier way? Can I turn a crosstab query into a table?

	ABE	GED	Mod1	Mod2	Mod3
157834	am		4a
159236

[June7]

The source data is normalized structure? You did a crosstab then query the crosstab 28 times?

Have to take a guess about data structure but I expect the easier way would be a query that joins the Students table with the StudentsClasses table (join type - Include all records from students...) then use that query and the Classes table to do a Find Unmatched query.

[survivo01]

It worked! I had to create a query with classes and students for your suggestion to work.
Thanks