Generating same records only with different date

[boge]

Hi
I have a form where I am entering lot of records where only the date is different . In order to shorten this I need a querry that will (activated with a button on the same form) generate records in some other table (or in the same) with those records entered in the form and will have a field where will be put single dates in timeframe of starting and end date that I can enter in the form instead of single date.

Thanks in advance for your time!

 

[The_Doc_Man]

I'm not going to dwell on this, but the records that you are storing in this manner probably violate proper normalization rules - the ones that describe the requirements of record dependency on the prime key. You aren't describing such a thing.

Having said that, there is also the matter that a simple query can be started to run your update - but there will not be a simple way to stop it. You can do this with code or you can struggle your way through some DateAdd functions. But this is best done, not in a query but in a code segment.

 

[boge]

Hi

It seems that the complete solution is in another thread at the forum http://www.access-programmers.co.uk/forums/showthread.php?t=79731&highlight=replace+record

Thanks anyway Doc_Man!