Can't you just open Access and fix the query?

Otherwise you might need to recreate the entire query, and update the
database with it. Which means you would need access to the query to
know what's in it. Which means you should be able to just update the
query directly.

--JP


On Nov 22, 6:28 am, Andrew wrote:
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