Why isn’t this working?
I’m toying around with SQL in MS Access. I have a table, called “TransEx.” I have a query that goes:
SELECT DISTINCT F1, F2
WHERE F4 = “SPA 200”.
That one works. Then I have another query, that goes:
And when I try to run that one, it says Access can’t find the table or query Query1. But there it is right there on my screen. By which I mean, to the right of the “TransEx” tab I see another tab that says “Query1,” which contains that first query I typed up above. “Query2”, meanwhile, is on the tab to the right of “Query1”, and it’s Query2 that claims its neighbor Query1 doesn’t exist…
What obvious thing am I missing here?