Delete Query...

I have a database with a field named PULLED? that is either a "Y" or blank.

How do I write code to go through and delete all the people with a "Y" in
the PULLED? field, and put them into a new database in the same directory
called PEOPLE PULLED.db?

I started out, but got a little nervous because the query was writing
automatically to the :PRIV: directory... I was unsure just what checking I
should be using (for existing tables, etc.).

-b


.

Relevant Pages

  • Re: How I dramatically sped up DB file updating
    ... > Yet, if it takes 28 seconds to update 500 records on a Access database, ... > I do not remember to have found noticeable speed differences when batch ... This approach isn't great...it doesn't give consistent times. ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)
  • curious about command buttons
    ... This of course isn't a life or death situation for my database, ... Stuart K. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Getting Date Only
    ... > formatting to mm/dd/yyyy. ... > This is the same code I used in another database using Nowinstead with ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • creating tables at runtime
    ... of the prev table. ... i have table called MSP_Number_Fields in Microsoft Project ... Server2003 database ...
    (microsoft.public.sqlserver.programming)
  • Re: date - # of days calcuation
    ... or should I redesign the database to put some other field in there? ... Please only reply to this newsgroup. ... I do not reply to personal email. ... Prev by Date: ...
    (microsoft.public.access.queries)