CrossTab Queries

[MLUNAG]

Created a cross tab query. Having trouble with Parameter dates. The cross tab query doesn't recognize begin date. Can someone suggest something diffrent to try?

 

[Fornatian]

Use a primary query to feed the crosstab and don't forget to explicitly reference the date parameters under Tools-Parameters to ensure the cross tab query works.

 

[Klubby]

I am having this same problem. The crosstab query is based directly on another query, which receives a date range input from a user on a form. The primary query runs just fine, but I get errors when trying to run the crosstab.

What do you mean by Tools-Parameters?

 

[Klubby]

Ok, I actually figured out where the Tools-Parameters are... but what needs to be input there? I tried copying the criteria into the parameter, but received invalid bracketing errors.... I've searched for other posts on this topic and they say these parameters and criteria need to be placed in both queries and in the Parameters dialog box. I'm not sue what I am doing wrong here.

 

[Fornatian]

Take a look at the crosstab sample in the Solutions.mdb installed with Access.

 

[Klubby]

Thank you!!

Whew, I'm pretty new to this crosstab query stuff, but finally figured it out.

For those newbies out there like me, in the parameter dialog box everyone says needs to be filled in also, remove the "Between" and "And" and all the brackets for EACH field. Essentially, you'll have two lines in this box, one for the start date field and one for the end date.

Brackets - no brackets... ahhhh!

Thanks for your help!