This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
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))
Yes it did! Thanks!
It seems you can not upload Access files. I may have found what is causing the error.
If 0 is named in the "on bill" field then it will show "#Div/0!" in the new FSC column. If I eliminate theses istances from showing like named it will sort fine.
Does this make sense?
Go to https://skydrive.live.com/
Log in with your Windows Live account (if you're not already logged in)
You may have to set up some things.
After that, open your Shared folder, then click Add Files.