use a colon in a query column title

[ndt]

I need to create a query where the title of one of the columns has a
colon in it. For example the title is Music:category and it is then
populated with the word "soul".

So i wrote it in the query like this

Music:category: "soul"

this didnt work because it has 2 colon's.

I tried putting the title in quotations like this

"Music:category": "soul"

but then the result is the title with quotation marks around it in the
table, like this

"Music:category"

I want it to show up like

Music:category

any idea on how to do this?

 

[Gina Whipp]

NDT,

Try: "Music: " & [Category]

Providing Category is the name of your field.

 

[ndt]

No didnt work

I've got a workaround now where I've just created a table with the
column headings without the quotes but with the colon, and then I am
just appending that table with new date, but if anyone has a better
solution, i'd love to hear it.

NDT,

Try: "Music: " & [Category]

Providing Category is the name of your field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

I need to create a query where the title of one of the columns has a
colon in it.  For example the title is Music:category and it is then
populated with the word "soul".

So i wrote it in the query like this

Music:category: "soul"

this didnt work because it has 2 colon's.

I tried putting the title in quotations like this

"Music:category": "soul"

but then the result is the title with quotation marks around it in the
table, like this

I want it to show up like

any idea on how to do this?- Hide quoted text -

- Show quoted text -

 

[Gina Whipp]

What is the name of the field that contains "Soul"?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
No didnt work

I've got a workaround now where I've just created a table with the
column headings without the quotes but with the colon, and then I am
just appending that table with new date, but if anyone has a better
solution, i'd love to hear it.

NDT,

Try: "Music: " & [Category]

Providing Category is the name of your field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

I need to create a query where the title of one of the columns has a
colon in it. For example the title is Music:category and it is then
populated with the word "soul".

So i wrote it in the query like this

Music:category: "soul"

this didnt work because it has 2 colon's.

I tried putting the title in quotations like this

"Music:category": "soul"

but then the result is the title with quotation marks around it in the
table, like this

I want it to show up like

any idea on how to do this?- Hide quoted text -

- Show quoted text -

 

[John W. Vinson]

I need to create a query where the title of one of the columns has a
colon in it.

Why?

Users should never even SEE a query datasheet. Tables are for data storage;
queries are for data assembly and selection; for data display use a Form for
onscreen use, or a Report for printing. The field can have any fieldname you
wish (one without blanks or special characters, if you want Access to play
nice with it); and you can put whatever label you wish on the form or report.

 

[ndt]

Why?

Users should never even SEE a query datasheet. Tables are for data storage;
queries are for data assembly and selection; for data display use a Form for
onscreen use, or a Report for printing. The field can have any fieldname you
wish (one without blanks or special characters, if you want Access to play
nice with it); and you can put whatever label you wish on the form or report.

The answer to "why" is because i want to create the query or table and
put it into a csv file and upload it to a system where the requirement
for that field is for the title of the column to be formatted with a
colon in it.

 

[Dirk Goldgar]

I need to create a query where the title of one of the columns has a
colon in it. For example the title is Music:category and it is then
populated with the word "soul".

So i wrote it in the query like this

Music:category: "soul"

this didnt work because it has 2 colon's.

I tried putting the title in quotations like this

"Music:category": "soul"

but then the result is the title with quotation marks around it in the
table, like this

"Music:category"

I want it to show up like

Music:category

any idea on how to do this?

Try

[Music:category]: "soul"

 

[John W. Vinson]

The answer to "why" is because i want to create the query or table and
put it into a csv file and upload it to a system where the requirement
for that field is for the title of the column to be formatted with a
colon in it.

You can still do so by setting the Caption property of the query field.

 

[Gina Whipp]

Missed that... you wanted in query/datasheet view! Try the caption property
of the field in the table.

 

[Dirk Goldgar]

Try

[Music:category]: "soul"

Nope, that doesn't work. I think the others may be right in telling you to
specify the Caption property of the field, but I don't know whether that
will export or not. If it doesn't, then you may have to write the header
row yourself using basic file I/O.