Rabu, 06 Agustus 2014

[MS_AccessPros] Using double quotes (") in SQL for a query

 


I need to concatenate a field [message] as part of a new field called [entry].

This is my failed attempt:

Entry: [Nayme] & " said " & Chr$(34)" "  & [Message] & "Chr$(34); "

The intention is that the field should show - John Smith said "It's a wonderful world".

The Microsoft help pages give this advice:

 The ANSI representation for double quotation marks is Chr$(34); you could assign this value to a string variable called strQuote. You could then construct the criteria argument

I really do not understand the various pages that I have followed to attempt to understand.

Is there a straightforward answer?

Many thanks,

Robin Chapple


__._,_.___

Posted by: Robin Chapple <robinski@westnet.com.au>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar