Criteria in Query cannot find table name

[Mike]

When I click on the run button, it says it cannot find my table. The table is
named QTD Data and I have it written just as below.

SELECT Store, Date, Line
FROM QTD Data
WHERE Store NOT IN
(SELECT DISTINCT Store
FROM QTD Data
WHERE Line = "RTS")


Thank you.




Create a new query. When the Show Table dialog box appears, just close it.
Next go to View, SQL View and paste the SQL statement in there. Save the
query with an appropriate name then run it.