Crosstab Query Error

A

Alex Brown

I am using a form field to provide input to a report as it
launches. Everything works fine with normal queries but
as soon as I use a crosstab query I get the following
error message:

"The Microsoft Jet database engine does not
recognize '[Forms]![Year Dialog]![yearlist]' as a valid
field name or expression."

I am using a base query - which is where the criteria
expression appears - followed by a crosstab query layered
on top that provides the data for the report.

Please help!

Thanks,
Alex
 

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

Top