Hi

I have the following code i am just trying to split the amounts between +ve and -ve amounts i am not sure how to do this below is the code ii have made

SELECT AR.*
FROM AR LEFT JOIN GA ON [AR].[AR name]=[GA].[GA name]
WHERE ((([GA].[GA name]) Is Null));
this currently outputs names and amounts in say column a and b - i am trying to split the amounts and have positive amounts in one col say b and -ve amounts in col c

tia