thenoisydrum
Registered User.
- Local time
- Today, 03:16
- Joined
- Jul 26, 2012
- Messages
- 52
Hello everybody,
We've all seen this error before and normally when I come across it I can see where the problem lies and I can fix it.
This time however I can't and I'm starting to get a little bit, shall we say, annoyed :banghead:
I am running a very simple query that divides profit over turnover to show the margin. I have many queries throughout my database that do this, here is my little formula;
Margin: Round(([profit]/[Turnover])*100,2)
Now, this runs just fine but if I put in a criteria of <10 I get the division by zero error. The reason I am confused is that there are no zeros or error values or even negative values in either of the profit or turnover columns?
Also I have an almost identical query in another database that has a <5 criteria in it and it works a peach.
Where the bejesus am I going wrong?
I have searched and searched online for a solution but all I am getting is the usual definition of the division by zero error.
Any help would be appreciated
We've all seen this error before and normally when I come across it I can see where the problem lies and I can fix it.
This time however I can't and I'm starting to get a little bit, shall we say, annoyed :banghead:
I am running a very simple query that divides profit over turnover to show the margin. I have many queries throughout my database that do this, here is my little formula;
Margin: Round(([profit]/[Turnover])*100,2)
Now, this runs just fine but if I put in a criteria of <10 I get the division by zero error. The reason I am confused is that there are no zeros or error values or even negative values in either of the profit or turnover columns?
Also I have an almost identical query in another database that has a <5 criteria in it and it works a peach.
Where the bejesus am I going wrong?
I have searched and searched online for a solution but all I am getting is the usual definition of the division by zero error.
Any help would be appreciated