Form Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that pulls data from one file it then has two subforms. The
data in the main form is updated by a file daily however I would like to know
if it is possible to take the data and move it to another table that would
contain all the informaion to another table if the person was to leave as
they will no longer show up in the data update but we would like to retain
the data after they leave as it looked on the day they go. For example: We
have a guy that comes in he is here for 2 or 3 years then leaves, he is no
longer in the data push we get from the server therefor we would not be able
to pull his data up unless we had some way to move it to another table for
future reference. Is this possible.
 
Maybe you could set up a table which would hold your "inactive" information.
When folks leave, you would move their data to the inactive information
table. You may need some type of union query so that you can look at
everything together.

Linda
 
Or you could add a status field.

Regards John

Linda Burnside said:
Maybe you could set up a table which would hold your "inactive" information.
When folks leave, you would move their data to the inactive information
table. You may need some type of union query so that you can look at
everything together.

Linda
Click to expand...
 
A status fild would be good however the data in the employee data table gets
written over each day with updated information so the emp # and othe
associated data would not be there. I would just like to be able to move the
information I need into another table and use it with a report or form for if
any one needs to go back and look at it again and still have all the data. I
tried to do a copy data and append to a new table query however it copys all
2000 + lines I just want it to copy the person who goes not the entire table.
 
It sounds like you need create a master table to keep
data across the time domain, which means that you would not
have to delete information before filling from file.

Regards - John
 
Back
Top