Can you add Blank Columns into a query?

[purceld2]

Is it possible to add blank columns into a query? I wish to add some blank named columns into a query so that when exported the spreadsheet can be used to collect data to be feed back into the database. ​

 

[Brianwarnock]

Yes Fred: " " will add a column named Fred and a blank, if the data is not going to be text you will probably have to quote some meaningful default.

Brian

 

[purceld2]

Perfect Thanks Brain