Crosstab with a filter

[Sue Compelling]

Hi All

Through this forum I've just discovered the delights of union queries and am
now trying to clean up some of my DBs.

I have the following crosstab query (derived from a union query, which is
derived from 5 select queries) which is presenting me with the following
error:

The Microsoft Office Access database engine does not recognise
'[forms]![frmreporting]![yrcombo]' as a valid field name or expression

NOTE: [forms]![frmreporting]![yrcombo] is a filter I use in all 5 select
queries - which work fine by themselves (including the union query).

Is there a way around this or can I not do this?

TIA

 

[Michel Walsh]

For a crosstab, you have to explicitly supply the parameter data type for
each and every parameter the crosstab will use (directly or not).


With Access 2003, you can do it in design view, from the menu, Query,
Parameters...



Vanderghast, Access MVP

 

[Sue Compelling]

That's brilliant Michel - thanks so much.

Now I can delete about 14 other queries I worte to produce a report!
--
Sue Compelling

For a crosstab, you have to explicitly supply the parameter data type for
each and every parameter the crosstab will use (directly or not).


With Access 2003, you can do it in design view, from the menu, Query,
Parameters...



Vanderghast, Access MVP

Hi All

Through this forum I've just discovered the delights of union queries and
am
now trying to clean up some of my DBs.

I have the following crosstab query (derived from a union query, which is
derived from 5 select queries) which is presenting me with the following
error:

The Microsoft Office Access database engine does not recognise
'[forms]![frmreporting]![yrcombo]' as a valid field name or expression

NOTE: [forms]![frmreporting]![yrcombo] is a filter I use in all 5 select
queries - which work fine by themselves (including the union query).

Is there a way around this or can I not do this?

TIA