I have a database that uses a bar-code reader to input data. The barcode uses the Pipe symbol "|" as a delimiter between data segements. I wish to query data out of an Access DB and place the pipe in the string using something like the following:
BarCode: "TEXT" & [TableName].[Field] & "|" & [TableName2].[Field]
Access will not let me enclose the Pipe in quotations to represent it as text. I get the error "The expression you entered has an invalid string". Virtually any other symbol or character I enclose in the quotations will work and print as text in the string. But not the Pipe?!?!