Crosstab with a filter

  • Thread starter Thread starter Sue Compelling
  • Start date Start date
S

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
 
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
 
That's brilliant Michel - thanks so much.

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


Michel Walsh said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top