Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Delete Info. - Access 2003

Discussion in 'Information Technology' started by Belladonna, Jul 28, 2006.

  1. Belladonna

    Belladonna
    Expand Collapse
    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...
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    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" <Belladonna@discussions.microsoft.com> wrote in message
    news:5333271D-0525-4D8F-AF1E-1C470DAAA3DF@microsoft.com...
    > 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...
     
  4. Belladonna

    Belladonna
    Expand Collapse
    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" 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" <Belladonna@discussions.microsoft.com> wrote in message
    > news:5333271D-0525-4D8F-AF1E-1C470DAAA3DF@microsoft.com...
    > > 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...

    >
    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Design.

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


    "Belladonna" <Belladonna@discussions.microsoft.com> wrote in message
    news:94108DBA-5B9B-4B84-B81C-51A8AB61BA23@microsoft.com...
    > 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" <Belladonna@discussions.microsoft.com> wrote in message
    > > news:5333271D-0525-4D8F-AF1E-1C470DAAA3DF@microsoft.com...
    > > > 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...

    > >
    > >
    > >
     
  6. Belladonna

    Belladonna
    Expand Collapse
    Guest

    Thanks!

    "Douglas J Steele" wrote:

    > Design.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Belladonna" <Belladonna@discussions.microsoft.com> wrote in message
    > news:94108DBA-5B9B-4B84-B81C-51A8AB61BA23@microsoft.com...
    > > 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" <Belladonna@discussions.microsoft.com> wrote in message
    > > > news:5333271D-0525-4D8F-AF1E-1C470DAAA3DF@microsoft.com...
    > > > > 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...
    > > >
    > > >
    > > >

    >
    >
    >
     

Share This Page