Re: Delete records containing certain info

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I tried what you said and it worked as a select query but I get an error
after changing it to a Delete query and executing.

The error reads: "cannot delete specified table"

I am trying to delete all records in one table that have the same ref number
in a second table.

The table which contains the reocrds to be deleted has a many to one
relationship with the "criteria" table.

What am I doing wrong?

Thanks

--
A MACKENZIE, CMA, MBA


"Duane Hookom" wrote:

Create a query that selects the records that you want to delete. Then switch
it to a delete query (find this in the menus) and make sure you have the "*"
in the query grid. You should always view the datasheet prior to running a
delete query so you can confirm the appropriate records will be deleted.

--
Duane Hookom
MS Access MVP
--

"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:353A3F6E-F433-43EF-9A66-4C22DA7AB0A3@xxxxxxxxxxxxxxxx
Duane,
I am fairly new to access and dont know how to set up delete queries. Can
you give explain in more detail pls?
Thanks
George

"Duane Hookom" wrote:

That's kinda how delete queries work. You can set criteria using "Like "
to
match text within a field.

--
Duane Hookom
MS Access MVP
--

"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70B4D442-99D4-4F7F-995F-639997CF0EB7@xxxxxxxxxxxxxxxx
Is it possible to delete whole records (rows) in a query or table that
contains certain "text" in a specified field?
Thanks
George






.

Relevant Pages

  • Re: Beginner query help please
    ... MS Access MVP ... Duane Hookom wrote: ... I've noticed that if you select all the query output (in this ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Beginner query help please
    ... MS Access MVP ... I've noticed that if you select all the query output (in this case ... Duane Hookom wrote: ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Tricky query question
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... dynamic monthly crosstab report solution found at ... July data minus June data) in a crosstab query? ...
    (microsoft.public.access.queries)
  • Re: Formula will not work with mail merge
    ... There is code that does this in the Query By Form ... > How do I push the records to a separate Word Merge format file? ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.queries)
  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)