Error 2329 (To create a crosstab query, ...)

D

Dale Fye

I've got a couple of crosstab querys that run great from the query design
mode. However, when I try to use the OutputTo method, I get the following
error message:

To create a crosstab query, you must specify one of more Row heading(s)
options, one column heading option, and one Value Option. I've got all of
these. Anyone know why the OutputTo method is not recognizing these
properly?

All three of these queries are based on another (Union) query, but they all
run properly from the query view. I even went so far as to copy the SQL,
paste it into a new query, and rename it. But that didn't work either.

Any help would be greatly appreciated.

Dale
 

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