Crosstab Error

[Guest]

Hi
I want to set a crosstab query that has a calculated field based on the
selected value from a dropdown on a form.

Can this be done?

The query Currently as follows:

Cost ppt: Sum([Billing Data]![Cost ppt]/1000)....This is the "Value" field
in the crosstab.

and I would want it to be as follows:

Cost ppt: Sum([Billing Data]![Cost ppt]/1000)*(Forms![Remedy]![Factor]

However i get an error message saying the following:

"The Microsoft jet dtabase engine does not reconise 'Forms![Remedy]![Factor]
as a valid field name or expression"

Is there a workaround

Many thanks in anticipation

Rgds

Colin

 

[Dave]

Make sure that you have identified the parameters in the crosstab query and
in any queries that support the crosstab query.

I think in this case you would need to visit the Query menu, then
clickParameters, and in the Parameter column, type
"Forms![Remedy]![Factor]", and than in the DataType column, select the
appropriate data type.

While you can get away without identifying parameters in other queries,
crosstab queries insist on them, at least in earlier versions of Access.

 

[Guest]

Dave,
.......my late-night hero! problem solved.....go home....phew!
Thanks!
Charlie

Make sure that you have identified the parameters in the crosstab query and
in any queries that support the crosstab query.

I think in this case you would need to visit the Query menu, then
clickParameters, and in the Parameter column, type
"Forms![Remedy]![Factor]", and than in the DataType column, select the
appropriate data type.

While you can get away without identifying parameters in other queries,
crosstab queries insist on them, at least in earlier versions of Access.

Hi
I want to set a crosstab query that has a calculated field based on the
selected value from a dropdown on a form.

Can this be done?

The query Currently as follows:

Cost ppt: Sum([Billing Data]![Cost ppt]/1000)....This is the "Value" field
in the crosstab.

and I would want it to be as follows:

Cost ppt: Sum([Billing Data]![Cost ppt]/1000)*(Forms![Remedy]![Factor]

However i get an error message saying the following:

"The Microsoft jet dtabase engine does not reconise 'Forms![Remedy]![Factor]
as a valid field name or expression"

Is there a workaround

Many thanks in anticipation

Rgds

Colin