Howdy:
I have an MS Access Query that I use a Docmd.outputto macro that exports the query to an Excel workbook on a monthly basis, named "Export.xls."
I then have monthly reports in Excel, this month called "June 2009.xls," that include a PivotTable that links to an external database, the "Export.xls" workbook.
Typically this runs fine, but I am now having the problem that some fields are totally empty in the PivotTable. The fields that import correctly are those where empty cells are output as a zero-length string, meaning that MS Query will pick up all the values in that field even if some records are essentially empty. However, the fields that DON'T include this zero-length string in empty cells are entirely ignored by MS Query, meaning that the records that DO have information in that field are empty in that field.
I hope this is clear enough to understand. Any help would be greatly appreciated.
Rgds,
Peter
I have an MS Access Query that I use a Docmd.outputto macro that exports the query to an Excel workbook on a monthly basis, named "Export.xls."
I then have monthly reports in Excel, this month called "June 2009.xls," that include a PivotTable that links to an external database, the "Export.xls" workbook.
Typically this runs fine, but I am now having the problem that some fields are totally empty in the PivotTable. The fields that import correctly are those where empty cells are output as a zero-length string, meaning that MS Query will pick up all the values in that field even if some records are essentially empty. However, the fields that DON'T include this zero-length string in empty cells are entirely ignored by MS Query, meaning that the records that DO have information in that field are empty in that field.
I hope this is clear enough to understand. Any help would be greatly appreciated.
Rgds,
Peter