Passing variables to a cross tab query

[Guest]

Hi all

Is there any way that I can pass a variable (year) to a cross tab query.
I know I can "hard code" it into the query itself as a selection but I want
to leave it so that a user coming in after me can change the year without
having to access the query itself? If I can not do this, is there any
workaround?

Thanks

 

[Allen Browne]

You can declare the parameter (Parameters on Query menu, in query design
view.)

Use the same name then in the criteria row of the query.

More info
http://allenbrowne.com/ser-67.html#Param

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...