Calculations in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

Either do the calculations in a query or directly in the report, but
there is no reason to save the calculation in a table.
 
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.
Click to expand...

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated field in a table 6
Form Calculations 2
How to calculate form field 1
calculations saved to table 6
forms 3
Form Calculations 4
Store calculated values? 3
Autoupdate calc in form 1

Back
Top