#error in query 1

[KimVong]

How can I make the #error in my query to equal to zero. The reason why it give me a #error becuase I some of my field is divided by zero.

any help is great

 

[scriverb]

We can fix that a couple of ways. Please post your SQL and identify the column that is causing the problem.

Bob Scriver

 

[KimVong]

select amtsold, price, [price]/[amtsold] as pf from table1

the column that I have a problem is the column with [price]/[amtsold], if the division is not by zero, then the number come out correctly, if it is divided by zero, then it shows #error in the query output
thanks for replying

 

[scriverb]

Try this:

select amtsold, price, IIF([amtsold]= 0, 0,[price]/[amtsold]) as pf from table1

This will analyze [amtsold] first and if zero(0) return a 0 else perform the division.

Bob Scriver