Groups > comp.databases.ms-access > #14467

Re: How to add a blank column to a query for CSV export.

Newsgroups	comp.databases.ms-access
Subject	Re: How to add a blank column to a query for CSV export.
From	Alan Carpenter <Not@iHome.nz>
References	<XnsAEF411B9DA62ANotiHomenz@yourdomain.com> <tdb0vv$35u42$1@dont-email.me>
Organization	Home
Message-ID	<XnsAEF4613AC19FCNotiHomenz@yourdomain.com> (permalink)
Date	2022-08-14 21:33 +0000

Show all headers | View raw

Ron Weiner <rw@domain.com> wrote in news:tdb0vv$35u42$1@dont-email.me:

> SELECT "" as Title, GeorgeContacts.[First Name], GeorgeContacts.[Last 
> Name],GeorgeContacts.[Mobile Phone]
> FROM GeorgeContacts;
> 

... which of course is exactly what I wanted.

I would swear on a stack of database manuals I tried that more than once.  
Oh well, I hope I like it in the Senile Care home I seem to be heading for.  

Thanks for that.  Take the rest of the day off.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar

Thread

How to add a blank column to a query for CSV export. Alan Carpenter <Not@iHome.nz> - 2022-08-14 13:44 +0000
  Re: How to add a blank column to a query for CSV export. Ron Weiner <rw@domain.com> - 2022-08-14 10:31 -0400
    Re: How to add a blank column to a query for CSV export. Alan Carpenter <Not@iHome.nz> - 2022-08-14 21:33 +0000

csiph-web