Re: Update with calculation

From: Marin Kostov (fire_and_forget_at_noname.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 12:57:30 +0300

The calculations made on form or report are the best way of storing
Calculated data. No, you cannot store the calculated number in the table.
Why?
Just because one control can have only ONE record source. If your record
source is a Table or Query, that control will be Bound to that Table or
Query. And if your control is calculated (in run-time), the Record Source
will be something like:
=[Quantity] * [Price]
When you save the Report, the record source Property of the control (the
formula) is saved too. So the next time you will not need to re-write te
formula. It is allready there!
And another good reason for using calculated controls - thedata is NOT
stored in the Table - it will NOT use disk space. Just thing about:
You have 5000 records, and when you prefrorm calculations, the data is
stored in the table... It will GROW and loose perfomance... 

-- 
Marin Kostov
Microsoft Office XP Master Instructor

Relevant Pages

  • Re: trouble with SUM function - Repost
    ... calculations in the record source query. ... calculation to be done in the report's record source query. ... Totals query to calculate the group total and then Join the ... I named this control txtProjectTotal. ...
    (microsoft.public.access.reports)
  • Re: Null values and calculations
    ... You can use the IIf() expression in the Control Source of a text box. ... another cause of #Error is calculated expressions when the report has no records. ... >> messages where this formaul was being used in a calculations. ...
    (microsoft.public.access.reports)
  • RE: form/ subform calculation
    ... it's control source. ... of the calculations underlying fields gets changed, the result stays the same, ... F-CutlistDetail subform, and use the calculated field in the query as the ... control source for [PCS]. ...
    (microsoft.public.access.formscoding)
  • RE: General question on an event
    ... you have a control that shows the total square feet. ... Dave Hargis, Microsoft Access MVP ... I would suggest the applied tax rate be stored in the table at the line item ... the Calculations txtbox and when it changes it will update the txtSalesTax ...
    (microsoft.public.access.formscoding)
  • Re: Refreshing Data on a subform
    ... Try using the AfterUpdate event of the *form* (not the control) to requery ... Use the Requery if you need to get your other subform to reload its data ... > the calculations on frmC, but I want the screen to update automatically, ...
    (microsoft.public.access.forms)