I have a query with a field name of "Street", however, I would like
it
to read "CAT:STREET ".
This query is exported to a csv file that requires the format of the
later. Currently the csv file is modified manually after the fact.
In the query I have been unable to create an expression that does not
choke on the ":". Or is there a way to add the Header Field Name at
the time of the TransferText?
Any suggestion as to how allow this in the query, or maybe allow this
in the export.
Thanks in advance 2 6777
Switch the query to design view, and enter the alias for the field name in
square brackets.
This kind of thing:
SELECT Surname, Street AS [Cat:Street] FROM MyTable;
Can't say I really recommend this. Access is likely to get confused at some
point with the colon in the name.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Clint Stowers" <Ab***********@ gmail.comwrote in message
news:11******** *************@z 24g2000prh.goog legroups.com...
>I have a query with a field name of "Street", however, I would like
it
to read "CAT:STREET ".
This query is exported to a csv file that requires the format of the
later. Currently the csv file is modified manually after the fact.
In the query I have been unable to create an expression that does not
choke on the ":". Or is there a way to add the Header Field Name at
the time of the TransferText?
Any suggestion as to how allow this in the query, or maybe allow this
in the export.
Thanks in advance
Sorry: switch the query to SQL View to make the change.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...
Switch the query to design view, and enter the alias for the field name in
square brackets.
This kind of thing:
SELECT Surname, Street AS [Cat:Street] FROM MyTable;
Can't say I really recommend this. Access is likely to get confused at
some point with the colon in the name.
"Clint Stowers" <Ab***********@ gmail.comwrote in message
news:11******** *************@z 24g2000prh.goog legroups.com...
>>I have a query with a field name of "Street", however, I would like it to read "CAT:STREET ".
This query is exported to a csv file that requires the format of the later. Currently the csv file is modified manually after the fact. In the query I have been unable to create an expression that does not choke on the ":". Or is there a way to add the Header Field Name at the time of the TransferText?
Any suggestion as to how allow this in the query, or maybe allow this in the export.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: adrien |
last post by:
Hi,
i start with javascript and i saw a lot of examples, but sometimes there is
";" on each end of line, sometimes only certain lines, sometimes nowhere.
So my question is: where must i put ";" in a javascript (in function, out
function)?
thanks for help
ad
|
by: Jukka K. Korpela |
last post by:
I noticed that Internet Explorer (6.0, on Win XP SP 2, all fixes
installed) incorrectly renders e.g.
&harr &euro &Omega
literally and not as characters denoted by the entities, but if a
semicolon is appended to each of the entity references, they work.
I'm pretty sure that previous versions of IE rendered them by the
specifications. I first thought this has something to do with XML (i.e.
maybe IE pretends to play a little bit of XML...
|
by: Eric-Sebastien Lachance |
last post by:
Hey there,
I decided to just create a 100% height and width div that filled the
space over a background header image, and add an onclick event to
redirect to the my index... Doesn't seem to work in FireFox only, just
in IE. Here's the code:
<div id="headerimg"><div style="width: 100%; height: 100%; cursor:
hand; cursor: pointer;"
onclick="top.location.href('http://www.monamouchtim.com/');"> </div></div>
|
by: Danny |
last post by:
I have to make a database that will export to a tab delimited file, but the
requirements are
a field name with a . in the field so
Is it true access will not allow this?
If not, how can I get around this?
Thanks
|
by: Ray Stevens |
last post by:
Is it possible to place a company icon (logo) in the browser address field
so that if a user copies it as a shortcut to his desktop the icon will be
there.
For example, like this: http://espn.go.com/
| |
by: markryde |
last post by:
Hello,
I saw in some open source projects a use of "!!" in "C" code;
for example:
in some header file
#define event_pending(v) \
(!!(v)->vcpu_info->evtchn_upcall_pending & \
!(v)->vcpu_info->evtchn_upcall_mask)
whereas evtchn_upcall_pending is of type unsigned char
(and also evtchn_upcall_mask is of type unsigned char).
|
by: MLH |
last post by:
If I run ?", ",""
in the immediate window,
I get a comma followed by 13 spaces.
It is difficult for me to understand this.
|
by: manchin2 |
last post by:
Hi,
Can anybody please provide the information about """ and its use, if possible please provide an example.
1)<tm:bom-expression>{Conf.getEquityConfLookupFields().getEventFieldText("AdditionalDisruption","Change in Law")}</tm:bom-expression>
2)07:41:08 Default ( call ( . ( call ( . Conf getEquityConfLookupFields ) ) getEventFieldText ) ( , AdditionalDisruption Change inLaw ) ) value=Not applicable
Can you please...
|
by: fran7 |
last post by:
Hi, from help in the javascript forum I found the error in some code but need help. This bit of code works perfectly, trouble is I am writing it to a javascript function so the height needs to be in "" instead of "" otherwise I get an error message.
Can anyone suggest how to write it so that it writes " instead of "".
I have tried all combinations of adding " to the code but as soon as I think I am there I get throw out again.
if...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |