D
Dom
I am trying to export a Crosstab query to Excel using the CopyFromRecordset
function.
The crosstab query is based on another query which, in turn has criteria
from a form.
When I run the code from the form I get a 'No value given for one or more
required parameters' error.
With the code stopped and the form open, the same SQL works just fine in the
query designer.
Can I run the Crosstab SQL in code or will I have to do a Pivot Table in
Excel?
Thanks
Dominic
function.
The crosstab query is based on another query which, in turn has criteria
from a form.
When I run the code from the form I get a 'No value given for one or more
required parameters' error.
With the code stopped and the form open, the same SQL works just fine in the
query designer.
Can I run the Crosstab SQL in code or will I have to do a Pivot Table in
Excel?
Thanks
Dominic