Parameters in Crosstab query based reports

[bomalley]

Hi all,

I have the exact same problem as is described in this thread:

thread703-439075

I see that someone named Falcon99 offered a suggestion, but I'm not clear on exactly what they were referring to. That thread is old enough that it can't be replied to, hence this new post.

Can someone provide an example?

 

[redwoodly]

there's a few ways to do this.


1. (from Access Help for OpenReport):

To open a report and restrict its records to those specified by the value of a control on a form, use the following expression:

[fieldname] = Forms![formname]![controlname on form]

The fieldname argument is the name of a field in the underlying table or query of the report you want to open. The controlname on form argument is the name of the control on the form that contains the value you want records in the report to match.

or 2. you can have the criteria in the query =
Forms![formname]![controlname on form]. (off-hand, can't remember if this is allowed in a cross-tab, but if not - then create a query first with this criteria and do the cross-tab based on this new query.)