Splitting Field input in report

[breukelen]

I like to split the negative and positive values
of a field data into two columns in a report.
With Progress and Excell there is no problem ,
but as I am new to Acces I can not find the trick

For instance: Field Netto
-100
500
600
-400

I like output in report : Netto-plus Netto-min
500 -100
600 -400

Thanks in advance for your help

Gunter

 

[demoman]

I can tell you one way to do it. You will create two expressions:

Netto-plus:IIF([Netto]>=0,[Netto],"&quot
Netto-minus:IIF(Netto]<0,[Netto],&quot;&quot

Then locate the expressions on your report. You can define the expressions in report design, or in the query which drives it. I prefer to do it in the query because the report designer can sometimes get a little snitty with expressions.

cheers

 

[breukelen]

Demoman ,

Thanks for your reply .
Will try it out this weekend.

Best regards,

Gunter

 

[breukelen]

Worked fine,

Thanks again