f the URN field is a Text datatype in the Client Data table, then there
should be no need to put a ' character in front of the field in the query.
My testing shows that a text field is exported to EXCEL as a text field,
even if the field contains only number values. Putting the ' character in
front of a text field will give you two ' characters at the beginning of the
value (click into the EXCEL cell and you'll see two ' characters at the
beginning of the value, not one) -- so the first one is "hidden" and you see
the second one in the cell when viewing the spreadsheet.
You should use the ' character as a prepended character only if the field
datatype is a numeric one.
<MS ACCESS MVP>
"Garry" < XXXX@XXXXX.COM > wrote in message
news:Y1__h.4489$ XXXX@XXXXX.COM ...