I have divide by zero problems

[spow]

Let's say I have a table that looks like the following:

Table1:
[Name AB Hits]

And I have a query that calculates:

Avg = Hits / AB

But sometimes, the entries in the table have AB = 0.

When I run this query, it outputs an error, how can I make it output 0 for Avg if AB = 0 ?

Similar to the basic statement:
If AB = 0 THEN AVG = 0 ELSE AVG = Hits / AB

Only I imagine this would be in SQL or the design mode of the query. Thanks in advance for any help.

Spow

 

[930driver]

In the query use the following for the Field

Avg = IIf([AB] = 0,0,[Hits]/[AB])

This uses the Immediate If function. The logic is if the first parameter is true return the second parameter, else return the third parameter. Bear in mind that IIf functions are relatively slow, but sometimes it's the only way to make something work. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"