Was looking for any tips to avoid this issue right now that I am having. When I run this append query it gives me an "! cannot divide by 0". When I look at the query in design view I don't see any division problems. It has one instance of a multiplication problem [BE1j Final productivity]![dept Rate] * 1.2. I have looked to see if there is any zeros in the information tables but no luck. Any tips or help someone could provide would be appreciated.
Thanks,
Nick