Changing the table query in Access

Question

https://imgur.com/n3d0b2v In this picture I'm showing how the two queries are showing up as different names, I know that I can rename the custom query tab, but when I open it up it holds the same wrong name, I know in SQL in the from statement I could write AS "new name" but it doesn't seem to work here, any solutions?

Thanks

question from:https://stackoverflow.com/questions/66055629/changing-the-table-query-in-access

Answer 1

You are using custom groups, and if you change its navigation name, it would change only the shortcut name, not the query name. To do so, change the navigation pan view from "custom" to "object Type" then change the original query name.

I stopped using custom view because of such conflict