Data Collection via Email

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
[email protected]
 
N

NetworkTrade

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.
 
Top