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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#Error 2

Status
Not open for further replies.
RonCT

RonCT

Technical User
Dec 11, 2003
37
0
0
US
I'm trying to run a query with a simple calculation.
[#Services]/[#Members]
Some of the results are returned with #Error
Is there a way for the result to return 0 and not #Error?

Thanks!
 
Sort by date Sort by votes
Hi!

Instead of:

[#Services]/[#Members]

Use:

IIf([#Members] = 0, 0, [#Services]/[#Members])

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst
 
Upvote 0 Downvote
Or to catch NULLs
Code: 
IIf([COLOR=red]NZ([/color][#Members][COLOR=red])[/color] = 0, 0, [#Services]/[#Members])
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
275
dhookom
dhookom
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
206
MDGarcia
MDGarcia
soloracer
  • Locked
  • Question
Run-time error 3075 in QDF 2
Replies
7
Views
94
Andrzejek
Andrzejek
PeDa
  • Locked
  • Question
Join on table1.var1 = -table2.var2 gives 'Join expression not supported' error
Replies
9
Views
105
combo
combo
Moss100
  • Locked
  • Question
Syntax Error (missing opertator) in query expression..... 1
Replies
5
Views
79
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top