434,808 Members | 1,477 Online
Need help? Post your question and get tips & solutions from a community of 434,808 IT Pros & Developers. It's quick & easy.

# REPORT; If Null return "0"

7 Replies

 P: n/a Ron, Where would I put this? The Report? The Query? Apr 17 '06 #3

 P: n/a "Drum2001" wrote in message news:11*********************@e56g2000cwe.googlegro ups.com... Ron, Where would I put this? The Report? The Query? 1.In On Format event of the report If isnull(me![Number of Completions])l, Then Me![Number of Completions] = NZ(Me![Number of Completions],0) Else Me![Number of Completions] = NZ(me![HoursWorked],0) End If 2. In the Control source property of the field in the report = NZ([Number of Completions],NZ([HoursWorked],0)) 3. As a calculated field in the query NZ([Number of Completions],NZ([HoursWorked],0)) As NumberofCompletions Apr 17 '06 #4

 P: n/a None of those worked for me. #1 Kept Errored Out #2 Displayed all the resultes as ERROR# #3 Getting "Wrong Syntax" error Any ideas why? paii, Ron wrote: "Drum2001" wrote in message news:11*********************@e56g2000cwe.googlegro ups.com... Ron, Where would I put this? The Report? The Query? 1.In On Format event of the report If isnull(me![Number of Completions])l, Then Me![Number of Completions] = NZ(Me![Number of Completions],0) Else Me![Number of Completions] = NZ(me![HoursWorked],0) End If 2. In the Control source property of the field in the report = NZ([Number of Completions],NZ([HoursWorked],0)) 3. As a calculated field in the query NZ([Number of Completions],NZ([HoursWorked],0)) As NumberofCompletions Apr 18 '06 #5

 P: n/a "Drum2001" wrote in message news:11**********************@g10g2000cwb.googlegr oups.com... None of those worked for me. #1 Kept Errored Out #2 Displayed all the resultes as ERROR# #3 Getting "Wrong Syntax" error Any ideas why? Can you give me examples of the code you entered? Apr 18 '06 #6

 P: n/a GOT IT! Thank you to all those who have helped me! Apr 20 '06 #8

### This discussion thread is closed

Replies have been disabled for this discussion.