transferring redundant data

  • Thread starter Thread starter AW
  • Start date Start date
A

AW

Hi All
I'm a newbie to Access and have been pondering the following issue and
wonder if it's achievable and how to do it.

Any assistance would be gratefully received.

I have a table (tblMaster) which lists a number of jobs. If jobs are
complete, they are marked as such in a check box.

What I wish to do is on opening or closing the table, have completed jobs
removed from tblMaster and transferred to another table-which is added to
and not over-written. These completed jobs being stored indefinitely in a
new table.

Is this do-able?

TIA

Al@N
 
It's doable, but why bother? Unless you're talking about tens of thousands
of jobs in the table, simply have your query ignore those records that havea
the Completed field checked off.

Although, on rereading your post, it sounds as though you may be updating
the tables directly, rather than using a form. It's always preferable to use
a form for updates.
 
Doug

Thanks for the reply. I'll give it further thought.
As you say I'm working with tables and not forms and am trying to cut down
the size of the master tablewithout losing redundant data.

Cheers

Al@n
 
Back
Top