Cross Tab Parameter Error

[cdogstu99]

I have the following Cross Tab Query, and it prompts me for the two dates and company name but i'm getting the following error when i try to run it: "The expression is typed incorrectly or is too complex to be evaluated"...Any help????Thanks!

PARAMETERS [Forms]![Cancellations By Tier]![BeginningDate] DateTime, [Forms]![Cancellations By Tier]![EndingDate] DateTime, [Forms]![Cancellations By Tier]![cboInsuranceCompany] Value;
TRANSFORM Sum(qryTierBreakdown.Tier) AS SumOfTier
SELECT qryTierBreakdown.[Effective Date], qryTierBreakdown.[Insurance Company]
FROM qryTierBreakdown
WHERE (((qryTierBreakdown.[Effective Date]) Between [Forms]![Cancellations By Tier]![BeginningDate] And [Forms]![Cancellations By Tier]![EndingDate]) AND ((qryTierBreakdown.[Insurance Company])=[Forms]![Cancellations By Tier]![cboInsuranceCompany]))
GROUP BY qryTierBreakdown.[Effective Date], qryTierBreakdown.[Insurance Company]
PIVOT qryTierBreakdown.[Co/Assoc];

 

[dhookom]

What is the actual data type of cboInsuranceCompany? I would expect to see Text or Double or Integer or similar, not "value".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[cdogstu99]

Hi Duane, cboInsurance Company is a list of Company names. So, I took your hint and changed it to Text and I'm still getting the same error message....

 

[dhookom]

Try change it back to just a totals query to see if it works. There may be an issue with qryTierBreakdown but it is difficult to tell without seeing its sql.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]