Append Query + Date Incriment

[jnr927]

I want a query that will append a date from one table to another, however I want it to incriment by one day. Is this possible? For example:

tblTable1
07/20/2005
07/25/2005
07/28/2005

ActionQuery - tblTable1 appends to tblTable2 and incriments one day:

tblTable2
07/21/2005
07/26/2005
07/29/2005

Is there a way?

 

[Rich]

Look up the DateAdd function, but why would you want to store what appears in effect to be a calculated value?

 

[jnr927]

Thanks!

JNR