Data Collection via Email

  • Thread starter Thread starter TREVOR
  • Start date Start date
T

TREVOR

I have set up a table in ACCESS to track hours worked on a given project.
The table is updated using the "Collect Data Through Email Messages Wizard."
But I want the incoming data to add to, not over-write, the project hours
previously posted. Is there a way to do that? If so, what is the routine?

Thanks,

Trevor
(e-mail address removed)
 
make it 2 step; collect data to Table1 which is intented to be overwritten
each time; but make an append query of table1 to your permanent table that
runs each time....so that once the data is appended to the permanent, then it
is ok to overwrite Table1.
 
Back
Top