Query help!!

I have two tables. Table1 and Table2.

Table 1 has coloumns
colID
colSt -- The values are A, B, C and D.
colDate
ColMachinery

Table 2 has columns
colID
colType - W, X, Y or Z
colInventory

 The input to the query is Date Range(colDate of Table 1). ColID is the primary and foreign key for the tables.
Now I want a query that will list the output something like this..

Date Total of colSt Total of colSt Total of TOtal of Total of Total of

       with Status A with Status B type W type X type Y type Z

Can someone help?

Thanks in advance,
Scotty. Received on Sun Oct 23 2005 - 22:48:52 CDT