Negative and postivive number

[libby]

I have someone who is using Access like a check register.<br>
He wants to enter all numbers as a positive number, but he wants Access to view the credits as a positive number and the debits as a negative number. Each entry is has an accompanying field that indicates if it is a credit or debit. I would like to write code that tells says something like this. If an entry is designated as a debit make that number negative and if an entry is designated as a credit make that number positive.<br>
<br>
My purpose in this is to have a running sum report and not need to unique columns of numbers to calculate it. Am I approaching this correctly? Is there another way to do this?<br>
<br>
libby@bendcable.com<br>

 

[bitbrain]

Are your values stored in a table? Form?<br>
<br>
You can always write a function that returns a signed number.

 

[libby]

Values are stored in a table, but data entry is done in a form.<br>
<br>
How do I write a function that returns a signed number? Though we do not care if the number has a negative sign in front of it. The debits just need to work as a negative in the calculated text boxes of the report, etc.<br>
<br>
Thank you. <br>
libby@bendcable.com

 

[Lehtoant]

Make table where you have two fields: CheckType and Factor<br>
Insert two records: Credit,1 and Debit,-1<br>
Make a query with data table where you link checktypes and make calculated field Factor*Sum and make a report based on this query.<br>
<br>
<br>
Al

 

[RonB]

I have a similar problem in one of my programs. Each month I create a recordset of payments. All the amounts are stored as positive numbers but are identified by a code that designates them as either debits or credits. I created a function that reads every record in the recordset and if the tran code is a debit I simply multiply the debit amount by -1 which coverts the amount to a negative number. Now you can use the values in that recordset to do whatever calculations you want.

 

[MapMan]

Let's assume you have a field called 'crdr' for the flag and a field 'amt' for amount.<br>
<br>
You can use the following:<br>
<br>
if crdr = 'c' then <br>
amt=amt 'credits are positives<br>
if crdr = 'd' then<br>
amt = 0 - amt ' debits are negatives<br>
Else<br>
msgbox &quot;Please enter &lt;C&gt;redit or &lt;D&gt;ebit&quot;, &quot;Invalid Entry&quot;<br>
End If<br>
End If<br>
<br>
<br>
Or some derivation from that. But I think you get the point.<br>
<br>
HTH,<br>
<br>
Mapman<br>