service call management

[Guest]

I am using Service Call Management database which I downloaded from office
site. On the workorders by customer subform, it is multipling out for the
sales tax calculation each individual part, I need the sum of all the part
totaled then multipled by the sales tax, this is the expression that is
defaulted in the program.
=[Workorder Parts]!Quantity*[Workorder Parts]!UnitPrice*[SalesTaxRate]
How can I make it the sum off all the parts in that particular workorder and
then multiplied by the sales tax rate?
Thank you!

 

[Larry Linson]

I am using Service Call Management database which I downloaded from office
site. On the workorders by customer subform, it is multipling out for the
sales tax calculation each individual part, I need the sum of all the part
totaled then multipled by the sales tax, this is the expression that is
defaulted in the program.
=[Workorder Parts]!Quantity*[Workorder Parts]!UnitPrice*[SalesTaxRate]
How can I make it the sum off all the parts in that particular workorder
and
then multiplied by the sales tax rate?
Thank you!

I don't think you are going to find much support here for details of
templates -- people had too much difficulty because they'd spend time and
effort looking at the basic template in order to answer questions, only to
later discover that the person who asked the question had modified something
and failed to mention doing so.

What you show appears to be an expression that might well be in the Control
Source of a Control on a Report. If that is done as part of each Detail
Line, you may be able to move it to the Footer and apply similar logic to
the total, but you may have to write a similar expression in VBA code in the
Footer's OnPrint statement.

Larry Linson
Microsoft Access MVP

 

[Guest]

Why don't you use the sum function on the form unless you are looking for
something eye pleasing to you. The sum of the already totaled with taxed
total will be the same value. Sometimes taking a existing form and modding
it to your custom application is harder than starting from scratch. With it
being a subform I would recommend that the subform be based off a query and
let the query do the calculations for the total and then use a unbound box on
the main from to display the sum with sales tax. But that is only one way to
do it.

I guess I am saying there are many ways and the best way is to form fit it
to your application and end goal. There is a lot of good reference in the
help files and if you google it online.