I am using the following the SQL statement in VBA to query an Access
database. The statement is supposed to query two different columns and
concatenate them together, but it gives me the error "Invalid use of vertical
bars" Can anyone tell me what the syntax of the concatenation statement
should be

The statement I have now is: Src = "SELECT SerialNo || Batch FROM Reference
WHERE Entry =" & "" & Entrynum & ""