Cross-Tab Query

[Smeg77]

I've recently been having a few problems with getting a cross tab query to work. I'm currently using MS Access 2000.

I've created a query that I know want to use for the basis of my cross-tab.

I'm only after having it produce a tab of Part Type by Month using a count of all Clients.

When I use the wizard it sorts everything out fine, but when it runs I keep getting the same error message:

"The Microsfot Jet database engine does not recognize "[Start Date]" as a valid field name or expression"

In my main query I have it set so I can choose a date range using the criteria "Between [Start Date] and [End Date]" Is there a way of getting a cross tab to work using a user defined date range. I've also got fields that I have changed the column names on, EG. ClientName to Client Name (Client Name: ClientName) it is also having issues with these.

Any help would be very appreciated.

 

[reclusivemonkey]

Use "Between #[Start Date]# and #[End Date]#"

 

[Jon K]

In my main query I have it set so I can choose a date range using the criteria "Between [Start Date] and [End Date]"

You need to declare the data type of the parameters [Start Date] and [End Date] in the query.


Open the main query in query Design View.
Select menu Query, Parameters...
Type [Start Date] in the parameter column, select the correct data type in the next column.
Do the same for [End Date].
Click OK.
.

 

[Smeg77]

You need to declare the data type of the parameters [Start Date] and [End Date] in the query.


Open the main query in query Design View.
Select menu Query, Parameters...
Type [Start Date] in the parameter column, select the correct data type in the next column.
Do the same for [End Date].
Click OK.
.

Worked a treat Thankx very much