C
CW
I have a number of currency values in a table which should have been created
as negative amounts as they are for credit notes.
Unfortunately my database wasn't working properly until John Vinson helped
me out with the code to apply a minus sign if the current form was of type
"Credit Note".
That's working fine now, but I need to correct all those previous entries.
Rather than go through them all manually, could I do an update query and if
so, what would the syntax be, to change the field value from a positive into
a negative amount?
Many thanks
CW
as negative amounts as they are for credit notes.
Unfortunately my database wasn't working properly until John Vinson helped
me out with the code to apply a minus sign if the current form was of type
"Credit Note".
That's working fine now, but I need to correct all those previous entries.
Rather than go through them all manually, could I do an update query and if
so, what would the syntax be, to change the field value from a positive into
a negative amount?
Many thanks
CW