Unanswered: Access report to Excel - dropping fields (columns)
I am running into difficulty when I try to export a report using the OfficeLinks (from a menubar) to an Excel file. The report is based on a crosstab query where the columns are calculated using IIF statements (Eg: 1: Sum(IIF(..., ansTrue,ansFalse). Most of the columns are missing from the Excel file, and from the looks of it if the first record contains zero amounts in the column then that column is not created in Excel.
I prefer to use the OfficeLinks instead of writing additional code to export in another matter, if possible.