drew - it seems to work to a point, it just divides it twice, ex 10/10/10=.1, it should only do it once, ex 10/10=1 (or multiplies it twice if I change it to multiply). Other calculations are done fine in the program, but i cant figure out why I can't get this one to work. I'm trying to follow other setups, altho none are division (that I remember), they are multiplication.

There is alot of linked tables to another Access db, as well as where it pulls the data via odbc (Program as 120+ tables, quires, macros, modules).. The divisor is in the linked access db, plus it has to only do it to the certain accounts and items. We are looking at getting a real program to do this, but for now we are stuck with this.

I will try do what the video you linked has, but we use no forms for this.. All it does, is grab data and put it in a special format mandated by MSA (