Trying to sum values in a report footer

SteveL13 used Ask the Experts™
I'm trying to sum values in the report footer.  The value I'm trying to sum is txtQty1 where a field named QLBreakoutSortOrder is null.  I don't know how to write the control source.  Can someone help?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Not sure what the full scope of this question is, ...

But you can certainly convert Nulls to zeros by using the NZ() function...
NZ(QLBreakoutSortOrder,0 )
...or use an IIF:
IIF(isnull(QLBreakoutSortOrder),0,QLBreakoutSortOrder )

To be sure, you will have to post a bit more about this issue.
...or simply post a small sample db that illustrates this issue, ...and clearly explain what you need the result to be...
John TsioumprisSoftware & Systems Engineer

=Sum(Nz(Your field,0))
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
I think what you are looking for, is in the ControlSource of the textbox in the report footer, use:

=Sum(IIF(isnull([QLBreakoutSortOrder]),0, txtQty1) )

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial