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!

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.

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!