Duplicate a record 2 weeks later

[dmkennard2]

Hi,
I have a company that delivers skips to customers. I input the data on a subform for the delivery of the skips which includes the date (Taken from the main form), address, skip type, type of job(deliver/collect/Swap) etc.....

Is it possible to duplicate that entry (if it is a delivery or swap only) 14 days later and change the field "Deliver" to "Collect"?

Thanks in advance
Dazz

 

[Remou]

You can use an append query.