Auto Delete

  • Thread starter Thread starter Jaundice Boy the Moron
  • Start date Start date
J

Jaundice Boy the Moron

How can I set up an automatic delete of some data in a few
fields of a couple of tables.I would like to put a button
on a form that deletes the data in these fields so that it
will be ready for the next days input.

Thanks ahead of time for your assistance.
Jaundice Boy the Moron
 
How can I set up an automatic delete of some data in a few
fields of a couple of tables.I would like to put a button
on a form that deletes the data in these fields so that it
will be ready for the next days input.
Click to expand...

You would run an Update query updating those fields to NULL in the
selected records.

BUT!!!

This is NOT typical. Overwriting the same record day after day is very
unusual; normally if you have different data on different days, you
would store it in new records so that you have a historical record.

What's this table? What information is being stored? Why do you want
to edit an existing record rather than adding new records (perhaps to
a related table rather than to your main table)?
 
Back
Top