[Accessusergroup] Delete Query Filtered on Select Query
Noah.A.HELENIHI at odot.state.or.us
Fri Aug 11 16:25:24 PDT 2006
Does anyone know how to build a Delete Query filtered by the results of
a select query? I ran a find unmatched query. I want to use the results
of that query to delete all of the unmatched records. I just can't
figure it out. I tried to turn the "Find Unmatched" Select Query into a
Delete Query and that did not work. (Access keeps asking me from what
tale do I want to delete the records). So, I tried some other ways. No
matter what I try, I keep running in to one of two different error
messages-- depending on how I set up the Delete Query. First, I build
the query and only include the table from which I want to delete the
records. Then I write the name of the previous query in the "Criteria"
row. For some reason, Access won't do this and it prompts me to input
the value. Then, I include both the table where I want to delete records
and the query in the new Delete Query. When I do this, Access keeps
telling me to tell it what table to delete the records when the table is
sitting right there in the "Table" row!
How does this work? Please, Help!
Noah Helenihi <mailto:noah.a.helenihi at odot.state.or.us>
Procurement Programs Coordinator
ODOT Procurement Office <http://www.oregon.gov/ODOT/CS/OPO/>
(503) 986-5757 Phone
(503) 986-4469 FAX
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the AccessUserGroup