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!
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!
