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...

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Belladonna" <(E-Mail Removed)> wrote in message
news:5333271D-0525-4D8F-AF1E-(E-Mail Removed)...
> 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...

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" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Belladonna" <(E-Mail Removed)> wrote in message
> news:5333271D-0525-4D8F-AF1E-(E-Mail Removed)...
> > 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...
>
>
>

Design.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Belladonna" <(E-Mail Removed)> wrote in message
news:94108DBA-5B9B-4B84-B81C-(E-Mail Removed)...
> 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" wrote:
>
> > 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.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "Belladonna" <(E-Mail Removed)> wrote in message
> > news:5333271D-0525-4D8F-AF1E-(E-Mail Removed)...
> > > 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...
> >
> >
> >

Thanks!

"Douglas J Steele" wrote:

> Design.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Belladonna" <(E-Mail Removed)> wrote in message
> news:94108DBA-5B9B-4B84-B81C-(E-Mail Removed)...
> > 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" wrote:
> >
> > > 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.
> > >
> > > --
> > > Doug Steele, Microsoft Access MVP
> > > http://I.Am/DougSteele
> > > (no private e-mails, please)
> > >
> > >
> > > "Belladonna" <(E-Mail Removed)> wrote in message
> > > news:5333271D-0525-4D8F-AF1E-(E-Mail Removed)...
> > > > 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...
> > >
> > >
> > >
>
>
>