Exporting only new records (since last export)

[may1hem]

How is it possible to export on the records that were created since the last export?

Also, I want to export only these new records through a command button on the swichboard. How is this possible?

I thought that perhaps I could have an extra field in the table, a check box which is unticked by default, so that when an export is requested only the unticked records are exported and as each record is exported then the check box is ticked so that the next time that records is not exported.

By the way, I am using Microsoft Access 97.

Thanks in advance,

May

 

[Rolliee]

Why not open the table and check them all against the 'new records?'