How to use Criteria or Parameter in Crosstab query?

[ProwlingEyes]

I have a table that has three columns: Nationality, Gender, and Date. First I had the problem of grouping the Nationality column by Gender. That i resolved by creating a crosstab query. Now, I want to put a criteria on Date field so that when the query is run it will ask for the date input and will only show the Nationality and Gender result for specific dates. But when I write something in Criteria field it shows an error saying: "The Microsoft Access database engine does not recognize "[Registration Date]" as a valid field name or expression"..
help please.......

 

[pbaldy]

http://support.microsoft.com/kb/209778

 

[highandwild]

I would create a SELECT query upon which the CROSSTAB query is based.

The parameter can be in this query. You can test that this query works before setting out the CrossTab query.

It is good practice not have field names with spaces as this will sometimes cause you problems but I am not sure if this the cause of the current problem.

 

[pbaldy]

I am not sure if this the cause of the current problem.

It's not; the link describes the cause and the solution.