I am getting an overlow error, and have no idea what starts this problem, or how to go about solving this.
My data is simple,
1) table with three fields
prod_no txt
qty number/double
lcm_cost number/double
2) Query1 that groups prod_no, and sums qty and lcm_cost
3) Query2 divides lcm_cost/qty by IIf(IsNull([SumOfQty]),0,([SumOfLCM_AMOUNT]/[SumOfQTY])), and this is the query where I get the overflow error.
I have changed Query1 so the criteria for qty is >0, and this seems to have solved it. But I am not sure what was wrong in the first place.
Please, any hints are highly appreciated!
GaborH
My data is simple,
1) table with three fields
prod_no txt
qty number/double
lcm_cost number/double
2) Query1 that groups prod_no, and sums qty and lcm_cost
3) Query2 divides lcm_cost/qty by IIf(IsNull([SumOfQty]),0,([SumOfLCM_AMOUNT]/[SumOfQTY])), and this is the query where I get the overflow error.
I have changed Query1 so the criteria for qty is >0, and this seems to have solved it. But I am not sure what was wrong in the first place.
Please, any hints are highly appreciated!
GaborH