Negative value will not show "-" sign?

[winston01]

Thank you for reading.

On a report I have created text boxes to show sums for Deposits, withdrawals, and balances. When the balance is a negative balance, it shows as a positive number.

I'm using:
=Sum([depositamount])
=Sum([Withdrawalamount])
=Sum([Depositamount]-[Withdrawalamount])

The results are correct, but it will not show if it is negative?

I appreciate any help you can give me.

 

[dhookom]

Your question isn't clear. You state

When the balance is a negative balance, it shows as a positive number

Then you state

but it will not show if it is negative

Can you provide some sample records, existing display, and expect/desired display?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[winston01]

The sytem reads:

Deposits: $2,000
Withdrawals: $3,000
Balance: $1,000

The $1,000 should read -$1,000

Thank you.

 

[dhookom]

Are you showing only one record? Does a single record have fields for Deposits and a field for Withdrawals?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Zonie32]

not sure this will help, but in one of my reports I set my balance format to Standard with Auto decimal places and it shows the "-" negative.