Assigning criteria in cross tab query not working

[rehanemis]

Hi,

I have simple cross tab query (as shown in the attached snap shot). I just want to get result when I chooses the DepID from MainBoard. I am getting error message.

Any idea how to resolve the issue.

Thanks in advance.

 

[pbaldy]

Note the parameters section, required for crosstab queries:

http://allenbrowne.com/ser-67.html