| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change MS Access query from Excel
Hi,
Can someone please put me out of my misery. I've been working on this for hours. In an Access database called 'TEST.mdb' I have a query called 'qry_My_Test'. I want to change the 'criteria' From SELECT Tbl_Comm_Data.DEPT_NO FROM Tbl_Comm_Data; To SELECT Tbl_Comm_Data.DEPT_NO, Tbl_Comm_Data.DEPT_NAME FROM Tbl_Comm_Data; Thanks -- Andrew 221108 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using excel to access MS Access saved query | Excel Programming | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Run Access query from Excel, input value to query being value in c | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Using InputBox to change query criteria in Access | Excel Programming | |||
Threaded Mode
