The correct answer is: C. At least one field.
A crosstab query is a type of query that summarizes data from multiple tables into a single table. The table you are querying must contain at least one field that is common to all of the tables you are summarizing. This field is called the “crosstab column”. The other fields in the table will be used to create the rows and columns of the crosstab table.
Option A is incorrect because a crosstab query does not require lots of confusing information. In fact, a crosstab query can be a very helpful way to summarize data and make it easier to understand.
Option B is incorrect because a crosstab query does not require more than 100 records. A crosstab query can be used to summarize data from any number of records.
Option D is incorrect because a crosstab query does require at least one field. The field that is common to all of the tables you are summarizing is called the “crosstab column”.