I have a table with one field (Short text) named EVTS#
It is a 6-digit number. Ex: 123456
I am trying to write an update query for the field to look like this:
“123456”,
I believe I may have too many or too little quotes.
Can you please let me know where I need to fix?
Code: Select all
“”” & [EVTS#] & “”” & “,”