E
esseryn
I am using Access 97.
I want to following to happen in a select query and table:
Field_1 Field_2
text string "text string"
Field_2 needs to be a concatenation of Field_1 where quotation marks
are concatenated to the beginning and end of Field_1.
I used these two syntaxes in the QBE window:
Field_2: """"&[Field_1]&""""
Field_2: chr(34)&[Field_1]&chr(34)
Note: 34 is the ASCII code for " i.e. quotation marks.
The query results and table display fine using either method.
However, I need to be able to paste the table or select query into a
text file.
When I copy and paste to MS Word 95 or Notepad I get this in Field_2:
"""text string""" as opposed to "text string" In other words, the
quotation marks are in triplicate instead of single.
So far the only way I could get it to display right is to paste the
record set of Field_2 as a table in MS Word 95. Then convert that
table to text. But that is an extra step I would like to avoid.
How do I get it to paste the literal "text string" instead of """text
string"""
I want to following to happen in a select query and table:
Field_1 Field_2
text string "text string"
Field_2 needs to be a concatenation of Field_1 where quotation marks
are concatenated to the beginning and end of Field_1.
I used these two syntaxes in the QBE window:
Field_2: """"&[Field_1]&""""
Field_2: chr(34)&[Field_1]&chr(34)
Note: 34 is the ASCII code for " i.e. quotation marks.
The query results and table display fine using either method.
However, I need to be able to paste the table or select query into a
text file.
When I copy and paste to MS Word 95 or Notepad I get this in Field_2:
"""text string""" as opposed to "text string" In other words, the
quotation marks are in triplicate instead of single.
So far the only way I could get it to display right is to paste the
record set of Field_2 as a table in MS Word 95. Then convert that
table to text. But that is an extra step I would like to avoid.
How do I get it to paste the literal "text string" instead of """text
string"""