Jul 15, 2004 #1 dsea Technical User Jul 15, 2004 2 US How can you make a count on a field say zero instead of just leaving it blank? dsea
Jul 15, 2004 #2 synapsevampire Programmer Mar 23, 2002 20,180 US Depends on how you're building the report. A quick and dirty way is to create a formula to use to count such as: If isnull({table.field}) then 0 else 1 Now count the formula. -k Upvote 0 Downvote
Depends on how you're building the report. A quick and dirty way is to create a formula to use to count such as: If isnull({table.field}) then 0 else 1 Now count the formula. -k
Jul 16, 2004 #3 lbass Technical User Feb 9, 2002 32,816 US Now SUM the formula. -LB Upvote 0 Downvote