473,406 Members | 2,259 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Use of ":" in Query Fieldname

I have a query that I export as a csv file.

The problem is I want to create a Fieldname such as "CAT:STREET" from
a field currently named "STREET"

For obvious reasons it don't like the placement of the ":". Any
thoughts as to a work-around?

Thanks in advance.

In the meantime I'll just go in and rename the field after it's
generation.

Oct 12 '07 #1
2 1446
On Fri, 12 Oct 2007 07:28:22 -0700, Clint Stowers
<Ab***********@gmail.comwrote:

How about CatStreet?

Otherwise use square brackets.

-Tom.
>I have a query that I export as a csv file.

The problem is I want to create a Fieldname such as "CAT:STREET" from
a field currently named "STREET"

For obvious reasons it don't like the placement of the ":". Any
thoughts as to a work-around?

Thanks in advance.

In the meantime I'll just go in and rename the field after it's
generation.
Oct 12 '07 #2
Clint Stowers wrote:
I have a query that I export as a csv file.

The problem is I want to create a Fieldname such as "CAT:STREET" from
a field currently named "STREET"

For obvious reasons it don't like the placement of the ":". Any
thoughts as to a work-around?

Thanks in advance.

In the meantime I'll just go in and rename the field after it's
generation.
Clint;

See: Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/kb/826763/

Harvey

Oct 13 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: MLH | last post by:
I have a block of text with about 19,000 characters - alphanumeric, punctuation, hard returns, etc... I would like to count the number of periods ( Chr$(46) ) appearing in the document. Whats a...
1
by: ad | last post by:
Hi, What is the difference between (string)dr and dr.ToString();
0
by: David P. Donahue | last post by:
I'm using C# to create an ASP .NET website backed by a MySQL database. One of the things I do often on the site is populate a DataList by binding it to a DataSet pulled from the database. However,...
2
by: crjunk | last post by:
I'm trying to write a piece of code that will programatically save a record automatically without me having to add a new ' Row.Item("ADD1") = txtAdd1.Text.Trim.ToUpper ' type command each time I...
4
by: bijoy | last post by:
I am in the process of upgrading my application db from Access to SQL Server. With the Access backend, I had queries such as "UPDATE table SET fieldName = True". SQL Server doesnt seem to like...
1
by: MJR | last post by:
Could anyone please help me change data in uppercase to data in propercase in MS Access?
3
by: perryclisbee via AccessMonster.com | last post by:
I have a query where I need all of the results to be assigned a single tracking number. Example: I run the query for all claims within a certain date parameter, for 10 different patient codes. ...
0
by: jeoffh | last post by:
Background: I am trying to "merge" some attributes into an existing XML column in my MS SQL 2005 database. The general idea is that I have an XML column in a table and I would like to update/delete...
1
by: veaux | last post by:
Question deals with linking tables in queries. I'm not a code writer so use the GUI for all my queries. Table 1 - Master Table 2 - Sub1 Table 3 - Sub 2 All 3 tables have the same key field....
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.