Delete query problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for the replies, but unfortunately none of them worked
Let me try to explain my problem better
I have a product table. There are descriptions such toys, furniture, ramps, pans, walkers.....etc
What I need to do is run a delete query where the descriptions that start with the letter R, are to be deleted along with all other records associated with that description. I have tried Like *R*, this does not work
I have also tried Left([cus_billname],1) but I am not sure what to place in these feilds. It will not run for me. I am new to Access, so I apologize if this seems like a trivial problem, but I am really struck and could use some help
I am assuming that I will need to call the Product Feild for the From column and the Description Feild for the Where column. Is this correct? I just don't know what to put in the criteria feild
Thanks
Michael
 
Michael

First, are you trying to delete the contents of fields (replace "Rutabagas"
with nothing), or delete any table rows where the Description field starts
with the letter "R" (Like R*)? The former requires an Update query, the
latter a Delete query.

If the latter, open a query design window and select the Delete-type query.
Select the table from which you will be deleting rows. Drag the "splat"
(asterisk) from the table window to the query grid. Drag the description
field from the table to the grid. In the criterion "cell" under the
Description column, enter the search criterion (e.g., Like R*).

In fact, to be safe, consider doing this query as a select query first, to
ensure that you really do want to delete all rows with Description starting
with "R" (this would include "Refrigerators" as well). If you agree that
all rows should be deleted, you can change the query type back to a Delete
query. One more safety measure -- you DO have a backup, right?!
 
Back
Top