Welcome to SPN

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

Sign Up Now!

calculated field

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

  1. Karla

    Karla
    Expand Collapse
    Guest

    How do I create a calculated field in a form for Access XP?
     
  2. Loading...

    Similar Threads Forum Date
    India Reading Calculated Banis Breaking News Mar 6, 2013
    Canada Huddersfield Sikh community leader Bakhshish Singh Bhullar dies... Breaking News Jan 27, 2014
    The ‘Flying Sikh’ on India’s lamentable track-and-field prowess Sports & Fitness Oct 4, 2010
    India India Can Never Beat China in Any Field Breaking News May 22, 2010
    US Defense Department Hiring Resident Aliens in Medical and Language Fields Business, Lifestyle & Leisure Dec 6, 2008

  3. BruceM

    BruceM
    Expand Collapse
    Guest

    If I understand the question, you can use a calculation as the control
    source of an unbound text box, or you can create a calculated query field.
    How to do that depends on what you want to calculate.

    "Karla" <Karla@discussions.microsoft.com> wrote in message
    news:9965E5C8-B8E7-4EC0-ABB7-6C561AED38FB@microsoft.com...
    > How do I create a calculated field in a form for Access XP?
     
  4. Karla

    Karla
    Expand Collapse
    Guest

    Bruce,

    Thank you for the response. I am trying to calculate costs of a job. For
    example, I am doing a scan job. It costs .05 per page. How would I create
    the calculation to work to get this formula to work if I enter in 2 pages or
    something like that.

    "BruceM" wrote:

    > If I understand the question, you can use a calculation as the control
    > source of an unbound text box, or you can create a calculated query field.
    > How to do that depends on what you want to calculate.
    >
    > "Karla" <Karla@discussions.microsoft.com> wrote in message
    > news:9965E5C8-B8E7-4EC0-ABB7-6C561AED38FB@microsoft.com...
    > > How do I create a calculated field in a form for Access XP?

    >
    >
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 15 Jun 2006 08:49:02 -0700, Karla
    <Karla@discussions.microsoft.com> wrote:

    >How do I create a calculated field in a form for Access XP?


    Several ways. The two simplest are:

    - Type an equals sign and the calculation expression into the Control
    Source property of a textbox on the Form:

    = [UnitPrice] * [Qty] * (1.0 + [TaxRate])

    - Put the expression into a vacant Field cell in the query upon which
    the form is based, preceded by the desired fieldname:

    TotalPrice: [UnitPrice] * [Qty] * (1.0 + [TaxRate])


    John W. Vinson[MVP]
     
  6. BruceM

    BruceM
    Expand Collapse
    Guest

    Format an unbound text box (I will call it txtExtendedPrice) as currency
    (click the text box, click View > Properties, click the Format tab, click
    the Format row, and select Currency). Assuming that the quantity is entered
    into a field named Quantity, put this into the Control Source for
    txtExtendedPrice (on the Data tab, in similar manner to the format selection
    described above):
    = [Quantity] * .05

    If the price could change in the future, you could format another unbound
    text box (txtUnitPrice) as currency, and set its Default Value (Properties)
    to .05. Then your unbound text box would contain:
    =[Quantity] * [txtUnitPrice]

    In a query, build a query based on your table. At the top of an empty
    column in query design view, put:
    Extended: [Quantity] * .05

    The field's name is [Extended]. Base your form on the query, and bind
    txtExtendedPrice to the field.

    "Karla" <Karla@discussions.microsoft.com> wrote in message
    news:B2A9AA5A-5927-4680-9E95-5074FD46020F@microsoft.com...
    > Bruce,
    >
    > Thank you for the response. I am trying to calculate costs of a job. For
    > example, I am doing a scan job. It costs .05 per page. How would I
    > create
    > the calculation to work to get this formula to work if I enter in 2 pages
    > or
    > something like that.
    >
    > "BruceM" wrote:
    >
    >> If I understand the question, you can use a calculation as the control
    >> source of an unbound text box, or you can create a calculated query
    >> field.
    >> How to do that depends on what you want to calculate.
    >>
    >> "Karla" <Karla@discussions.microsoft.com> wrote in message
    >> news:9965E5C8-B8E7-4EC0-ABB7-6C561AED38FB@microsoft.com...
    >> > How do I create a calculated field in a form for Access XP?

    >>
    >>
    >>
     

Share This Page