crosstab query

[Wesley Morgan]

IS it possible to obtain the criteria for a crosstab query from a form textbox control?
I am using linked tables in my database with two tables.
Thank you,
Wesley

 

[SforSoftware]

Yes, that's possible, in the same way is in a normal query. Only one thing: you've to assign the parameter also in the parameters-property of the query (Menu Query, Parameters)

 

[Wesley Morgan]

Please expand upon your comments. If I put the parameters value of the textbox control name or do I need to show forms and form name?

 

[dcx693]

Regarding SforSoftware's comments: I don't know if explicitly declaring your parameters using Query, Parameters is ever absolutely required. It's always a good idea, though.

Specifying criteria for a crosstab query isn't different than specifying criteria for a "normal' select query. If you want to reference a form control, do it the same way using this syntax:
Forms!formname!formcontrolname

 

[SforSoftware]

dcx, for a normal query it isn't required, but for a crosstab-query you have to. Don't ask why, but based on experience, it works only if you specify the parameters.

thank you for explaining the syntax when I was sleeping

 

[dcx693]

SforSoftware, you are right about having to define parameters for crosstabs. It's always a good idea to do it, but I wonder why it's required in crosstabs, but not "normal" queries.

 

[Pat Hartman]

The programmer that wrote the code to process the crosstab query probably followed the spec