Negative Values Using Access - ODBC Link

[egrill]

I am linking the tables in Access through my SQL server. It is accounting programming that uses status determine the type of document; 8 for sales order and 11 for credit orders. 11 are negative currency however, they are being puled as positives which throughs off the totals, etc.. Any one have a logic or way to make sure 11 status are credits.

[NeoPa]

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

MODERATOR.

[NeoPa]

Within Access you can say :

SalesVal: IIf([Status]=11,-[Sales],[Sales])

[egrill]

Within Access you can say :

SalesVal: IIf([Status]=11,-[Sales],[Sales])

Thank you. It worked perfectly.

[NeoPa]

No problem. Glad I was able to help :)