sum question

[lipin]

I have a report with a column of numbers both negative and positive. At the bottom of a this column I would like a sum of only the positive numbers in that column. How do you write this in the control source?
Tried
=Sum(PhysicalCount) >0 but no luck

is there a way to combine the 'sum' with the 'if > 0'

 

[Cosmos75]

Couldn't you just run a query that gathers the same info that's on the report and use criteria to only show positive value (i.e. >0) and then use the Totals in the query design and choose Group by Sum for the value in question and add a textbox with the control source tied to the sum in the query??

 

[Rich]

=Sum(Iif([MyField]>0,[MyField],0))