Crosstab Query and Form problems

[Cpowell]

This is an extension of an earlier post I had about my query not reading the values in my form. I solved the problem by removing the parameters line, but now my crosstab query (and the report chart based on it) will not work and gives me the "Jet database does not recognize '[Forms]![Customer Form 1]![Start] as a valid field name or expression". The solution to that is to add a parameters line to the query, but as stated earlier this makes the query return no records when it is run from the form.

If you were wondering my goal is that one of our departments needs to be able to search between two dates for an unknown number of customer records and then put them on a chart showing the total numbers of customers per month broken down by (i.e. pivoted on) country.

 

[pbaldy]

I think I was on that other thread, but lost track of it; sorry. The parameters line is required for crosstab queries. I wonder if Access is misinterpreting the data type of the parameters. Or perhaps this is a US date format problem. Can you post a sample db that does this?

 

[Cpowell]

Sorry I am new to posting how do I do that.

 

[pbaldy]

If you click on Post Reply or Go Advanced, you'll see a Manages Attachments button.

 

[petewilson44]

I'm having exactly the same problem....this is the first time, however, i've heard anyone say it may be because of the difference in date formats (I am a UK Access user) - i've tried all ways around the problem that have seen posted across hundreds of threads now but nothing works.

pbaldy, i was trying to get an email address or something i could contact you on but i'm guessing the forums want everything done through here.....

Is there a way of using parameters in crosstab queries???

 

[pbaldy]

Posting the questions and answers here leaves an archive people can search for later (as you did).

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778