Formula in table

  • Thread starter Thread starter Kim Jackson
  • Start date Start date
K

Kim Jackson

I have field [yr_saving] that is going to be for
reporting only and not used on a form. I have a formula
that I need to do the calculation, is there away to add
this to the table Or what is the best way to do this?
Thanks for you help.
 
Calculations cannot be done in a table... do them in your form in a field
bound to yr_saving... You don't have to show this field.

HTH

Tom.
 
Kim

If there's a chance that you have recorded a date already that contains the
"year-value" you are trying to save, save yourself the work. You can use
the Year([YourDateField]) function to calculate that value on the fly, in
your queries, and/or forms and/or reports. If you already have a date
stored, don't bother storing redundant data.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top