Subtract Query

[Guest]

I need to do an sql query to subtract one field from another on the selected
record in a table and update the first field. Can anyone give me a hint?

Thanks

 

[Douglas J Steele]

Something like UPDATE MyTable SET Field1 = FIeld1 - Field2

Try it on a copy first, of course!

 

[Guest]

Thanks
--
Barnie Gumble Esq

Something like UPDATE MyTable SET Field1 = FIeld1 - Field2

Try it on a copy first, of course!