Parameterized query in crosstrab

[Boon]

Is it possible to do this? I have tried and Access showed me an error.

thanks,

 

[Dale Fye]

Post your SQL, and the error message that Access provided.

1. You cannot try to insert the parameter in one of the columns of the grid
that you are using for either a RowHeader, ColumnHeader, or Value. Add
another column, change the GroupBy to Where, and put the parameter in the
Critieria line.

2. Next, declare the parameter. Right click in the grey area above the
query grid. You should see a Parameters option. Click on that. In the
Parameters dialog, enter the name of the parameter you are trying to pass,
and declare the data type. If you look at the SQL, it might look like:

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Boon]

Thanks a lot.

I am able to figure it out now.

Post your SQL, and the error message that Access provided.

1. You cannot try to insert the parameter in one of the columns of the
grid
that you are using for either a RowHeader, ColumnHeader, or Value. Add
another column, change the GroupBy to Where, and put the parameter in the
Critieria line.

2. Next, declare the parameter. Right click in the grey area above the
query grid. You should see a Parameters option. Click on that. In the
Parameters dialog, enter the name of the parameter you are trying to pass,
and declare the data type. If you look at the SQL, it might look like:

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.