| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SQL concatenation statement
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 & "" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
