Delete

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

Guest

Let me give you the exact question...Using a query, delete all records in the Product table where the description starts with the letter R.
I opened a query and what exactly do I put in the critiria slot. I am a beginner so be specific if you can Thanks Perry or anyone else that cares to help out
 
Hi Diane,

First, back up your database just in case.

Then, add your table to the query's source (you will be
prompted when creating a new query in design view).
Then, close the table selection dialog and change the
query type to a delete query (go to query on the menu and
choose Delete Query). Then, double click the asterisk in
the field list, and then double click the Description
field in the field list. On the criteria line under teh
description field, type:

Like "R*"

(actually if you type R* access should change it to the
above).

That should do it. You can either click the red
exclamation point to run the query, or you can save it
and close it, then run it from the main database window
by double clicking it.

HTH

-Ted Allen
-----Original Message-----
Let me give you the exact question...Using a query,
Click to expand...
delete all records in the Product table where the
description starts with the letter R..
I opened a query and what exactly do I put in the
Click to expand...
critiria slot. I am a beginner so be specific if you
can Thanks Perry or anyone else that cares to help out
 
Let me give you the exact question...Using a query, delete all records in the Product table where the description starts with the letter R..
I opened a query and what exactly do I put in the critiria slot. I am a beginner so be specific if you can Thanks Perry or anyone else that cares to help out
Click to expand...

Create a Query based on Product.

Select the Description field.

On the Criteria line type

LIKE "R*"

Open the query datasheet to display which records will get deleted
(just as a check).

Change the query to a Delete query.

Run it by clicking the ! icon, or save the query and run it by
doubleclicking the query name.
 
Back
Top