M
MWeber
We sell products to customers also we do application where we have to charge
labor and equipment. I have the products in one table and the labor and
equipment in another. On my forms the total for my invoice comes out right
except for a couple might be off by a couple of cents. But when I go to the
report and have to total several invoices together the total will usually end
up several dollars more than it should be. Because when I try to sum the
products, labor and equipment the labor and equipment Order ID is linking
itself to the products Order ID which in turn is making the sum box come out
ahead. Beause in my products query I have several products that we apply in
one day for that customer so that is why the sum box is coming out ahead.
What are my options?
labor and equipment. I have the products in one table and the labor and
equipment in another. On my forms the total for my invoice comes out right
except for a couple might be off by a couple of cents. But when I go to the
report and have to total several invoices together the total will usually end
up several dollars more than it should be. Because when I try to sum the
products, labor and equipment the labor and equipment Order ID is linking
itself to the products Order ID which in turn is making the sum box come out
ahead. Beause in my products query I have several products that we apply in
one day for that customer so that is why the sum box is coming out ahead.
What are my options?