Copy result to table

[mtagliaferri]

I am stuck to something very basic....

I have a field in a form that calculates the time elapsed between two times, I would like to copy/embed the result in the table that the form is linked on the after update.

I am aware that this is not the best approach as it makes the table heavier with data, but I am working with an old database which will require me to update to many queries with a calculated value.

Any help?

 

[pbaldy]

The "you want to store...anyway" bit:

http://allenbrowne.com/casu-14.html

 

[mtagliaferri]

Thanks Paul,

I know is completely the wrong approach, but it is an immediate fix before I go through editing 15 plus queries...

 

[pbaldy]

No problem. I assume it worked?

 

[mtagliaferri]

Yes it did!!!
Thanks

 

[pbaldy]

Happy to help!