Leaving a blank column in a query

[Kell2604]

Hi -

I am running a query which will ultimately be converted to Excel for
manipulation. I need it to have a few blank columns right in the middle.

I was hoping to insert a column at a certain location in design view of the
query. I would then like to run the query and have that column I inserted be
output blank. I have inserted the column but when the query runs it just
drops the column off. Is there anyway around this??

Thanks very much!!

 

[KARL DEWEY]

Add in design view like this --
Blank_1: "" for text.
Blank_2: 0 for number.
Blank_3: No for boolean

 

[John W. Vinson]

Hi -

I am running a query which will ultimately be converted to Excel for
manipulation. I need it to have a few blank columns right in the middle.

I was hoping to insert a column at a certain location in design view of the
query. I would then like to run the query and have that column I inserted be
output blank. I have inserted the column but when the query runs it just
drops the column off. Is there anyway around this??

Thanks very much!!

Since Excel doesn't have strong datatypes, I'd say just include

Expr3: ""

as a calculated field in the query. This will give a blank (text) field which
will export as a blank Excell cell.

 

[Kell2604]

That worked great - thank you. I knew I had to be missing something fairly
simple!!

Have a great day - thanks again!!

 

[Kell2604]

That's what I needed - thanks John!!

Since Excel doesn't have strong datatypes, I'd say just include

Expr3: ""

as a calculated field in the query. This will give a blank (text) field which
will export as a blank Excell cell.