Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DownEaster
- Order by date
-
If not null, sum a field?
Thanks - just tried the code in a new control for the total and it worked fine!- DownEaster
- Post #4
- Forum: Microsoft: Access Reports
-
If not null, sum a field?
In a report, I need to sum the contents of a field [$AMT] if another field [Code]= is not null. I have tried the following expression in the control source of the field I want to sum, but am getting a message "This control has a reference to itself" =Sum(IIf(IsNull([Code]),0,[$ AMT])) Any...- DownEaster
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
