I am using Microsoft Access 2002. I have the template that Microsoft created which is called Service Call Management, i believe. Anyway...under the workorders by customer it sums up with the workorder id, date received, date finished, workorder total, total payments and amount due. I had added a text box under the workorder tab called Shipping and Handling and on that page everything gets added up just fine...Now when I am at the workorder by customer page the workorder total is not adding the shipping and handling. The formula that is being used in that is this.... =nz([Parts Total])+nz([Labor Total])+CLng((nz({Labor Total])+nz([Parts Total]))*nz([SalesTaxRate])*100)/100 this works without the shipping and handling. If I had at the beginning line =DLookUP("[ShippingAndHandling]","Workorders") it will add the shipping and handling but will not change it for different workorder ids..Example...Shipping and Handling for Workorder ID 20 = $20.00 and Workorder ID 21 = $5.00....on the workorder by customer page it is adding $20.00 for both workorder id's....If anyone can help me out with this, it will be greatly appreciated. Thank You

[This message has been edited by pcuccia (edited 05-05-2002).]

From a glance I would say that your calculation does not include the Shipping & Handling Fields. As this does not usually get Taxed. To correct the calculation, add the fields to the calculation.