Exclude columns with no data

[Gee]

Is there an easy way to have a query exclude fields that are null?

I have FieldA, FieldB, FieldC, FieldD and FieldE, with multiple rows of data.



There is a form where the user checks a box with what data to include.

If FieldC has no data (is unchecked), I need to exclude it from the output so the Query headers and included data would be:
FieldA FieldB FieldD FieldE

Is there an easy way to do this? I've been all over looking.
The data is sent from the query to an Excel spreadsheet.

[June7]

Not within the Access query object.

Could use VBA code to open a recordset of only the desired fields then export the recordset data to Excel. However, this would not use TransferSpreadsheet method. Unless you use VBA code to modify the Access query object. This requires use of QueryDefs.

[Gee]

That isn't going to work for me because the data often has several hundred "OR" statements and that crashes the Query.

I can get the data into an Excel Spreadsheet, with the name "Delete" as the header for each of the columns to be deleted in the spread sheet...does anyone know the code to delete on open for the spreadsheet?

[June7]

Whenever I need some new code for Excel manipulation I use Excel macro recorder to generate code then clean it up.

Review http://www.ozgrid.com/VBA/auto-run-macros.htm