Export report to excel mssing data

[bobmac-]

Hi,

I have a report where there is usually duplicate data for the first of seven columns. If I turn Hide Duplicates to 'no' in the text box properties then the export to Excel is fine. When I put 'yes' the excel display is missing data at seemingly random places.
Any idea what may cause this?

Cheers
Bob

 

[boblarson]

Export the Query that the report is based on and not the report itself. The hide duplicates would affect the output as it attempts to do what is in the displayed report.

 

[bobmac-]

Thanks. Is there a way to hide duplicates in queries though?

 

[boblarson]

Thanks. Is there a way to hide duplicates in queries though?

No, and remember spreadsheets are different than Reports. They have different purposes and so the spreadsheet should have all of the data, duplicates as well in order to show a complete picture. But the Report doesn't need to as the way it is displayed is different.

 

[ions]

DoCmd.OutputTo acOutputReport, strReport, acFormatXLS, strFolderPath & strReportName & ".xls", True

Appears to extract whatever I see in Print Preview.