Positive and Negative Amounts

[Qualinwraith]

I need to make a coupel of statements that display the total (sum) of negative amounts and positive amounts from a single list of results which comtains both negative and positive values. The two answers need to be displayed in the footer of a report

 

[MStef]

Look at DemoSumPNA2000.mdb

 

[Qualinwraith]

I've opened the file and the sum of positive values and negative values is empty. What formulas do I need?

 

[namliam]

try something like:
LessThan0: Sum(iif([yourfield]<0,[yourfield],0)
MoreThan0: Sum(iif([yourfield]>0,0,[yourfield])

Seasons greetings from amsterdam

The Mailman

 

[Qualinwraith]

Thanks a lot and seasons greetings from Malta! It worked successfully! Would it be possible to divide the positive amounts and negative amounts when making a report view?

 

[namliam]

You can do which ever calculations on these totals you want on the report itself

 

[Qualinwraith]

When I said divide I meant having two sections with the first listing the positive and the seconds the negative ones

 

[namliam]

For that simply create an Iif([Yourfield]<0,"Neg","Pos")
Then "group by" your report on this field...

 

[Qualinwraith]

How do I have to specify this field in the Query creator? it's giving me a few bugs.

 

[namliam]

Bugs? Should work as is...

 

[Qualinwraith]

its telling me that the expression entered is too complex and that I should try to simplify it. What do 'I need to type in a a field name?

 

[Qualinwraith]

Finally I managed! thank again for all the help and patience!

 

[namliam]

For the sake of argument... What did you change to make it work?