Hi!
I have a table called ar
In it there is a filed called recordtype & one called amount.
The recordtype is a number between 1 & 9.
If record type is >5 then the amount should be posted to the result as negative.
can I do this with a single query?
I have a table called ar
In it there is a filed called recordtype & one called amount.
The recordtype is a number between 1 & 9.
If record type is >5 then the amount should be posted to the result as negative.
can I do this with a single query?