I'm having trouble writing a crosstab query. Basically, what I need it to do is take all entries that don't have a column heading, count them, and then lump them into one "other" category for the services we provide by race. For example:
Therapy Counseling Other
White 21 48 9
Black 19 33 7

(You have to use your imagination a bit with this; the #'s 21 and 19 should be a column under the heading of Therapy, 48 and 33 under Counseling, and 9 and 7 under Other). So far, I can't get it to count because there are no "Other" entries in the service field; essentially, in this example, I want it to count everything that isn't therapy or counseling. Any help?

[This message has been edited by Dugantrain (edited 03-28-2002).]

[This message has been edited by Dugantrain (edited 03-28-2002).]

Create a query that groups the categories and base the crosstab on that query rather than the table.

Select IIf(YourFld = "Therapy" or YourFld = "Counseling",YourFld,"Other") As MyGroup,...