Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

service call management

Discussion in 'Information Technology' started by POlsen, Jul 28, 2006.

  1. POlsen

    POlsen
    Expand Collapse
    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!
     
  2. Loading...

    Similar Threads Forum Date
    Canada Canadian Blood Services Calls for More Blood from Visible Minorities Breaking News Jun 14, 2011
    Sikh News King-Emperor's Appreciation Of Sikh Services. - Chandigarh Tribune Breaking News Aug 11, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Khalsa Aid Khalsa Aid - 16 Years Of Service To Humanity Sikh Organisations Apr 5, 2015
    Sikh Coalition Sikh Soldier Presses to End Ban on Sikh Military Service VIDEO/PHOTO Sikh Organisations Jun 2, 2013

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "POlsen" <POlsen@discussions.microsoft.com> wrote

    >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
     
  4. default105

    default105
    Expand Collapse
    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.
     

Share This Page