Hello all. I am preparing some data for export to Amazon.com. The data for the product's SKU needs to be surrounded by quote marks.
The field in my table is called sku. The output column sent to Amazon must be titled the same, sku.
I had thought to just concatenate quote marks around the data like this:
sku: """" & [sku] & """"
But I am getting a circular reference error because I am trying to reuse the field name as the alias.
I could use a make table query and create a temporary second table, but that seems like clutter.
Is there a better way to do this?
Thanks in advance!