CrossTab query doesnt recognize expression

Question

I am trying to make a lead report using crosstab and have it by date range.. this >=[Forms]![frmExportFiles]![txtOrderDate] And <[Forms]![frmExportFiles]![txtOrderDate2]" Works in any other query i have with those same tables but when i do crosstab it says " The Microsoft Access database engine does not recognize '[Forms]![frmExportFiles]![txtOrderDate]' as a valid feild name or expression.

I have office 365 access installed locally and its Version 2207

Here is the SQL View.

TRANSFORM Count(vdlist_temp.lead_id) AS CountOflead_id

SELECT vicidial_lists.list_name

FROM vdlist_temp LEFT JOIN vicidial_lists ON vdlist_temp.list_id = vicidial_lists.list_id

WHERE (((vdlist_temp.PostDT)>=[Forms]![frmExportFiles]![txtOrderDate] And (vdlist_temp.PostDT)<[Forms]![frmExportFiles]![txtOrderDate2]))

GROUP BY vicidial_lists.list_name

PIVOT vdlist_temp.status;

Answer 1

Hi,

In a crosstab query you have to declare the parameters as such, i.e. in design view of the query choose he tab Design - Parameters and enter the name (Forms!frmExportFiles!txtOrderDate etc.) and type of the parameter.

Servus

Karl