|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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
|
|
|