Results 1 to 1 of 1
Thread: Linked ODBC Query
2001-05-17, 03:14 #1
- Join Date
- Nov 2002
- Thanked 0 Times in 0 Posts
Linked ODBC Query
The following question was also previously posted on the Word Forum under the same title. Please excuse the multiple posting.
I have many queries in an Access2000 database that I insert into Word as fields using a simple SELECT sql statement like 'SELECT * FROM qryMYQUERY WHERE ID = 1'.
This works fine, except I do not want to show the ID field in the resulting Word table. I want to be able to change the qryMYQUERY in Access (including changing fields) and have it update in word. Basically, I want a query more like 'SELECT * EXCEPT ID from qryMYQUERY WHERE ID = 3'. (or a visibility option like Access allows)
Apparently there is no 'EXCEPT' reserved word in the SQL Language.
The only field that I guarantee to be in the query is the ID field. I don't want to read in the field names and 'build' the query because then I would lose the flexibility of keeping the query in Access.