Using Criteria in Crosstab Query 1

[Gucci2006]

I have a crosstab query that I would like to have the user define the criteria. When I set the criteria as stated below, I get this error message "The Microsoft Jet database engine does not recognize [Enter Current Month] as a valid field or expression"

Field: Month
Table: tbl_44900
Total: Where
Crosstab:
Criteria: [Enter Current Month]

Any assistance would be greatly appreciated

 

[Remou]

You need to set up parameters. Here is an example (SQL view):

[b]PARAMETERS Forms!frmForm!sdate DateTime;[/b]
TRANSFORM Count([Members].[ID]) AS CountOfID
SELECT [Members].[Code], Count([Members].[ID]) AS [Total Of ID]
FROM Members
WHERE ((([Members].[Date])=[Forms]![frmForm]![sdate]))
GROUP BY [Members].[Code]
PIVOT [Members].[Date];

You can also assign Parameters by right-clicking in the design grid or by choosing Parameters from the Query menu.