I am having trouble getting a the correct value type when linking OBDC - ACCESS

[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]

This is a double-post so I'm locking it.
The other is Negative Values Using Access - ODBC Link.