[AccessD] How to display positive or negative number in report

[Kostas Konstantinidis]

yeap...
now it works perfect

thank's Gustav

/kostas

-----Αρχικό μήνυμα----- 
From: Gustav Brock
Sent: Saturday, June 06, 2015 2:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to display positive or negative number in report

Hi Kostas

Oh, that's right - the original purpose of the functions was just to 
indicate positive/negative.

Use Abs to correct:

    ="some text <b>" & SgnStr([score]) & CStr(Abs([score])) & "</b> some 
other text"

/gustav


________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Kostas 
Konstantinidis <kost36 at otenet.gr>
Sendt: 6. juni 2015 13:41
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] How to display positive or negative number in report

Gustav,
just noticed that if the number is negative e.g. -2 it returns double minor

some text --2 some text

thank's
/kostas

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com