quick question (hopefully) - i've created a crosstab query with two fields as rows and one field as a column. i have one numeric field upon which i am doing a sum, however, i'd like to have more than one field to do a sum, and Access 2000 doesn't seem to take that.

(my way around seems to be to create two crosstab queries and then do a make table query to combine the data.)

am i missing something?