Crosstab with a filter

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
 
M

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
 
S

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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top