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
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