G
Guest
I'm looking at a DB written by someone else where a value (Text) for a
fieldname is 5'10".
I have a SQL string in a module looping thru a recordset which includes...
WHERE Fieldname = """ & R & """...where R is the String assigned to the
Fieldname...here R = 5'10"
As I recall, the 10" double-quote above cannot be included in coding like
this..in other words, just enter 5 10 in the Fieldname...my Apps exclude a
double-quote from being entered in the Field.
Is there a workaround if the user insists on 5'10" as an entry?
TIA - Bob
fieldname is 5'10".
I have a SQL string in a module looping thru a recordset which includes...
WHERE Fieldname = """ & R & """...where R is the String assigned to the
Fieldname...here R = 5'10"
As I recall, the 10" double-quote above cannot be included in coding like
this..in other words, just enter 5 10 in the Fieldname...my Apps exclude a
double-quote from being entered in the Field.
Is there a workaround if the user insists on 5'10" as an entry?
TIA - Bob