Query that would create blank columns

[jodjim]

My query looks like this:
SELECT Fld1, Fld2,'','','','','','','','','','','','',Fld13 FROM tbl_One

so that it will create 12 or more blank columns between Fld2 and Fld13. Is there a more 'professional-looking' query to get the same result? Thanks.

 

[AlexCuse]

Nope. You can select '' as BlankCol1 to give it a header if you want. Why do you need blank columns though?

Is it a union query?

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[jodjim]

Thanks, AlexCuse. Yes, it is a UNION query. I just left out the second part of it. The blanks will be useful when users will dump the results into Excel spreadsheet. When you say as BlankCol1, you mean ' ' as BlankCol1. So basically giving the column a name? Thanks, again.

 

[AlexCuse]

Yes, but for a UNION you may or may not need to do that (There is no point in giving a name to a column that is not in the first piece of the union query).

Hope it helps,

ALex

Ignorance of certain subjects is a great part of wisdom