I complete get it is hard to troubleshoot even when the op (me) does not know what the query does.

Little more background when the user opens up access, access is not using a access database it is pulling directly from the sql database, when going to the menu via the UI and the user pulls a master list for Design nothing appears the window comes back blank, when the pull the Capital Master list it comes back as it should, the Capital Master list is using the 2nd query I posted and the Design is using the query that I posted first and like I said does not work. When I click around in the in the UI I do get errors such as "can't find the object 'qryDesignML'" and "can't find the object 'qrDesignML'.','frmDesign',

Like I said earlier I backed up the database from a sql 7 server and restored it to a sql 2005 server, the users are now accessing the sql 2005 server there was no issue when the sql 7 server was housing the database.

I greatly thank you for the help with this.