Jul 15, 2004 #1 dsea Technical User Joined Jul 15, 2004 Messages 2 Location 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 Joined Mar 23, 2002 Messages 20,180 Location 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 Joined Feb 9, 2002 Messages 32,818 Location US Now SUM the formula. -LB Upvote 0 Downvote