Welcome to SPN

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

Sign Up Now!

Calculations in a Form

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

  1. Tdahlman

    Tdahlman
    Expand Collapse
    Guest

    I have some calculated text boxes in my form for reference while filling out
    the form. Is there a way to have these calculated text boxes post into a
    table. What I'm trying to do is get a report from data entered into my form
    and I don't want to try and recalculate this stuff in a query. Let me know
    what I can do.

    Thanks in advance
    Travis
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 11 Jul 2006 12:15:01 -0700, Tdahlman wrote:

    > I have some calculated text boxes in my form for reference while filling out
    > the form. Is there a way to have these calculated text boxes post into a
    > table. What I'm trying to do is get a report from data entered into my form
    > and I don't want to try and recalculate this stuff in a query. Let me know
    > what I can do.
    >
    > Thanks in advance
    > Travis


    Either do the calculations in a query or directly in the report, but
    there is no reason to save the calculation in a table.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 11 Jul 2006 12:15:01 -0700, Tdahlman
    <Tdahlman@discussions.microsoft.com> wrote:

    >I have some calculated text boxes in my form for reference while filling out
    >the form. Is there a way to have these calculated text boxes post into a
    >table. What I'm trying to do is get a report from data entered into my form
    >and I don't want to try and recalculate this stuff in a query. Let me know
    >what I can do.


    Actually you DO want to recalculate this stuff in a query.

    Storing derived data such as this in your table accomplishes
    three things: it wastes disk space; it wastes time (almost
    any calculation will be MUCH faster than a disk fetch); and
    most importantly, it risks data corruption. If one of the
    underlying fields is subsequently edited, you will have data
    in your table WHICH IS WRONG, and no automatic way to detect
    that fact.

    Just redo the calculation whenever you need it, either as a
    calculated field in a Query or just as you're now doing it -
    in the control source of a Form or a Report textbox.

    John W. Vinson[MVP]
     
  5. Tdahlman

    Tdahlman
    Expand Collapse
    Guest

    These are good points. I'll just do it again in a query then.
    Thanks
    Travis

    "John Vinson" wrote:

    > On Tue, 11 Jul 2006 12:15:01 -0700, Tdahlman
    > <Tdahlman@discussions.microsoft.com> wrote:
    >
    > >I have some calculated text boxes in my form for reference while filling out
    > >the form. Is there a way to have these calculated text boxes post into a
    > >table. What I'm trying to do is get a report from data entered into my form
    > >and I don't want to try and recalculate this stuff in a query. Let me know
    > >what I can do.

    >
    > Actually you DO want to recalculate this stuff in a query.
    >
    > Storing derived data such as this in your table accomplishes
    > three things: it wastes disk space; it wastes time (almost
    > any calculation will be MUCH faster than a disk fetch); and
    > most importantly, it risks data corruption. If one of the
    > underlying fields is subsequently edited, you will have data
    > in your table WHICH IS WRONG, and no automatic way to detect
    > that fact.
    >
    > Just redo the calculation whenever you need it, either as a
    > calculated field in a Query or just as you're now doing it -
    > in the control source of a Form or a Report textbox.
    >
    > John W. Vinson[MVP]
    >
     
  6. Tdahlman

    Tdahlman
    Expand Collapse
    Guest

    These are good points. I'll just do it again in a query then.
    Thanks
    Travis

    "John Vinson" wrote:

    > On Tue, 11 Jul 2006 12:15:01 -0700, Tdahlman
    > <Tdahlman@discussions.microsoft.com> wrote:
    >
    > >I have some calculated text boxes in my form for reference while filling out
    > >the form. Is there a way to have these calculated text boxes post into a
    > >table. What I'm trying to do is get a report from data entered into my form
    > >and I don't want to try and recalculate this stuff in a query. Let me know
    > >what I can do.

    >
    > Actually you DO want to recalculate this stuff in a query.
    >
    > Storing derived data such as this in your table accomplishes
    > three things: it wastes disk space; it wastes time (almost
    > any calculation will be MUCH faster than a disk fetch); and
    > most importantly, it risks data corruption. If one of the
    > underlying fields is subsequently edited, you will have data
    > in your table WHICH IS WRONG, and no automatic way to detect
    > that fact.
    >
    > Just redo the calculation whenever you need it, either as a
    > calculated field in a Query or just as you're now doing it -
    > in the control source of a Form or a Report textbox.
    >
    > John W. Vinson[MVP]
    >
     
  7. Tdahlman

    Tdahlman
    Expand Collapse
    Guest

    These are good points. I'll just do it again in a query then.
    Thanks
    Travis

    "John Vinson" wrote:

    > On Tue, 11 Jul 2006 12:15:01 -0700, Tdahlman
    > <Tdahlman@discussions.microsoft.com> wrote:
    >
    > >I have some calculated text boxes in my form for reference while filling out
    > >the form. Is there a way to have these calculated text boxes post into a
    > >table. What I'm trying to do is get a report from data entered into my form
    > >and I don't want to try and recalculate this stuff in a query. Let me know
    > >what I can do.

    >
    > Actually you DO want to recalculate this stuff in a query.
    >
    > Storing derived data such as this in your table accomplishes
    > three things: it wastes disk space; it wastes time (almost
    > any calculation will be MUCH faster than a disk fetch); and
    > most importantly, it risks data corruption. If one of the
    > underlying fields is subsequently edited, you will have data
    > in your table WHICH IS WRONG, and no automatic way to detect
    > that fact.
    >
    > Just redo the calculation whenever you need it, either as a
    > calculated field in a Query or just as you're now doing it -
    > in the control source of a Form or a Report textbox.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page