I have created a great crosstab report from a crosstab query, but I'd like to add info from another table that's static.

Example:
My Row Headings are: ClientName, CarrierName, and PolicyNumber
My Column Heading is MonthDue, and the Value is AgencyCommission

Now I'd like to add static information like EstimatedAmt and EffectiveDate to the left for each Policy.

There is a unique number, PolicySeq# on which I could join.

Do I need to create a larger query to bring together the crosstab query and the table, or do I create a select query which brings in the EstimatedAmount and EffectiveDate fields, and then create a totals query?

Your help is greatly appreciated!

I know the Crosstab wizard will only allow you to choose three columns as row headings but once the query has been created, you can open it yourself in design view and add the additional columns. Just be sure to select the RowHeading property for them. If the columns you need come from a different table, add it to the QBE grid and after drawing the proper join lines, select the additional columns.

Thanks Pat,
I can't wait to try this!
Kris