When sorting get error message Division by zero

Question

I have made a query to make new column in my Access database with the following fomula: FSC: Round([ex am1]/[on bill],3)

An example of the ending result of one is (EX AM1=00021500)   /  (on bill=464400)  The Result in this new column is FSC= 0.046.

I want to sort the new FSC Column from Z-A Decending and it gives me the Error message: Division by zero---Is their a way to fix something so I can sort this column?

Thanks

Answer 1

You might try uploading a zip file containing the database.

I thought that the expression I posted in my first reply would have taken care of 0 values. Does the following work better?

FSC: IIf(Nz([on bill],0)=0, 0, Round([ex am1]/[on bill],3))

Answer 2

I have a windows live acct, but not sure how to do it

Answer 3

Could you make a stripped down copy of the database (without sensitive information) available through a site that lets you upload and share files such as Windows Live SkyDrive, then post a link here?

Answer 4

I copied your suggestion and ran the query and the FSC Colum reads "#Error"

Any other suggestions

Answer 5

Try

FSC: IIf([on bill]=0, Null, Round([ex am1]/[on bill],3))