Hi there:
Here at work we have 2 bank accounts and transfer from one to another. I have written a nice database which tracks the movements with a synchronising query (changeto)that copies the transfer from one account to another, ON THE SAME DAY.
However in real life the transfer takes 3 days.
I recall having done something a while ago using TCursors and (I think) Locate to find the same date in the recipient table, then move down 2 records before adding it, but have since lost the code. Can anybody jog my memory? Weekends are not a problem; I have deleted them.
Thanks!
Here at work we have 2 bank accounts and transfer from one to another. I have written a nice database which tracks the movements with a synchronising query (changeto)that copies the transfer from one account to another, ON THE SAME DAY.
However in real life the transfer takes 3 days.
I recall having done something a while ago using TCursors and (I think) Locate to find the same date in the recipient table, then move down 2 records before adding it, but have since lost the code. Can anybody jog my memory? Weekends are not a problem; I have deleted them.
Thanks!