| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Database Field SQL Statement
OS: XP Pro SP1, Word 2003 SP2
DATABASE \d "C:\\Temp\\VerizonAirCard.mdb" \c "DSN=MS Access Database;DBQ= C:\\Temp\\VerizonAirCard.mdb;DefaultDir= C:\\Temp;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin; " \s "SELECT * FROM 'tblAirCard' " Ive been unable to change the select statement above to work properly. Ive tried to use tic, backslash and tic and backslash to denote the columns names and Ive tried using the tablename.fieldname, tablename!fieldname and just the field name by itself and everything generates the generic Word error unable to open data source. Any advice is appreciated. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge field+if statement+phone numbers | Mailmerge | |||
| Word: IF statement to merge a field only if another Field is popul | Mailmerge | |||
| Include an or option in IF statement: IF field = _ OR= _ then | Mailmerge | |||
| IF THEN ELSE Statement built by searching for a word in a Text Field | Mailmerge | |||
| IF THEN ELSE Statement built by searching for a word in a Text Field | Mailmerge | |||
Threaded Mode