crosstab query problem

[matt]

Hi,

I've got 2 tables that I'd like to include in a crosstab
query, but it doesn't seem to be working exactly how I'd
like it to. The following is the table structure:

Table 1 Fields:
RecordID [Key]
ClientID
CategoryID

Table 2 Fields:
CategoryID [Key]
CategoryName

I'm trying to build a matrix that shows, for each ClientID
in Table 1, a count of the # of occurrences of each
CategoryID. Something like this:

CategoryName1 CategoryName2 CategoryName3 ...
ClientID1 count1-1 count1-2 count1-3
ClientID2 count2-1 count2-2 count2-3
ClientID3 count3-1 count3-2 count3-3

 

[Cameo]

Create a Select Query combining Table 1 and Table 2, with a force inclusion
from Table 2 to Table 1.

Then create your crosstab query from the Select Query.

Cameo