Overflow error

[tstoneh]

Does anyone know what happens when you get an "overflow error"? How do you fix something like that?

 

[Dugantrain]

Entering a numerical value into a data type which is larger than that data type can handle will produce an overflow error. Division by zero can also do this. If it's the first, go into the table, go to the field in question, and look at what the type is set to. The Double data type is the largest numerical data type that MS Access has to offer.

 

[tstoneh]

OK division by zero is probably the cause. What are the exact steps to correct this error?

 

[Norie]

What are you doing that is creating the 'Overflow' error?

 

[tstoneh]

I have a formula that is dividing by 0 or there is no entry in a cell.

 

[Norie]

Could you post that formula and maybe an example of the data that is giving you trouble?

 

[tstoneh]

An example of the formula would be very simple (25-0)/0. I am just trying to fiigure out how to get rid of the error. In Excel you can do an iserror() type statement but in Access, which I am not as familiar with, I should be able to get rid of the error somehow. Any suggestions?

 

[Norie]

Could you actually post the formula?

You could use something like this:

MyCalc:Iif([Field1]<>0, [Field2]/[Field1], 0)

 

[tstoneh]

Here you go

SELECT [Fiscal 2005 Price File OFFICIAL V1].NIIN, [Fiscal 2005 Price File OFFICIAL V1].[ACT-CD], [Fiscal 2005 Price File OFFICIAL V1].[2005 LAC], [FY04 Std Exc LAC LRC].[2004 LAC Amt], [Fiscal 2005 Price File OFFICIAL V1]![2005 LAC]-[FY04 Std Exc LAC LRC]![2004 LAC Amt] AS [LAC Difference], ([Fiscal 2005 Price File OFFICIAL V1]![2005 LAC]-[FY04 Std Exc LAC LRC]![2004 LAC Amt])/[FY04 Std Exc LAC LRC]![2004 LAC Amt] AS [LAC % Change], [Fiscal 2005 Price File OFFICIAL V1].[2005 LRC], [FY04 Std Exc LAC LRC].[2004 LRC Amt], [Fiscal 2005 Price File OFFICIAL V1]![2005 LRC]-[FY04 Std Exc LAC LRC]![2004 LRC Amt] AS [LRC Difference], ([Fiscal 2005 Price File OFFICIAL V1]![2005 LRC]-[FY04 Std Exc LAC LRC]![2004 LRC Amt])/[FY04 Std Exc LAC LRC]![2004 LRC Amt] AS [LRC % Change]
FROM [Fiscal 2005 Price File OFFICIAL V1] INNER JOIN [FY04 Std Exc LAC LRC] ON [Fiscal 2005 Price File OFFICIAL V1].NIIN = [FY04 Std Exc LAC LRC].NIIN
WITH OWNERACCESS OPTION;

 

[Dugantrain]

[FY04 Std Exc LAC LRC]![2004 LAC Amt])/[FY04 Std Exc LAC LRC]![2004 LAC Amt]

A Statement like this would produce an overflow error if your denominator field (in this case [FY04 Std Exc LAC LRC]![2004 LAC Amt]) were 0. As Norie stated, wrapping an Iif function around this to first test for a denominator of 0 would do the trick. The Iif function basically takes a statement and returns one value if it is true, another value if that statement is false:

Iif([FY04 Std Exc LAC LRC]![2004 LAC Amt]=0,0,FY04 Std Exc LAC LRC]![2004 LAC Amt])/[FY04 Std Exc LAC LRC]![2004 LAC Amt])

Would return 0 if the denominator is 0. If not, it will return the percentage that you're looking for.