Delete Info. - Access 2003

[Guest]

In the Access database that I am working in there is a Column which states
"Attendance 2006". This column is used to determine the attendance for over
400 people. When the column was made the creator put check boxes in each row
for possible attendees. When the check boxes were converted to text all of
the rows (that had the check boxes) under "Attendance 2006" stated "no". I
have been trying to do mass deletions of all 400 "no" but, can't figure out a
way to do it (there is no cut, delete, etc. when you right click the
selection you would like to delete). If anyone could help me with this it
would be much appreciated...

 

[Douglas J. Steele]

Use a Delete query.

Go into the query builder and select New.

Drag the table in question into the space at the top, and drag the
Attendance 2006 field into the grid.

Put "No" as a criteria under that field (why, by the way, did you convert
from the checkbox to text?)

Run the query to make sure you get all 400 rows you're expecting.

Assuming you do, select Delete Query from the Query menu to convert that
query into a Delete query. Click on the exclamation point on the tool bar to
run it.

There's probably no need to save the query once you've run it.

 

[Guest]

Hi Doug,

Thank you for the response. When I go into the query builder and select
"new" I am given multiple options for the type of query I want to run:
Design, Crosstab, Matched, Unmatched, and Simple. What type of query do I
need to select?

Thanks.

 

[Douglas J Steele]

Design.

 

[Guest]

Thanks!

Design.