Formula in table

[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.

 

[tom]

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.

 

[Guest]

Thanks you..

 

[Jeff Boyce]

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>

 

[tom]

BTW... you shouldn't save calculations from other fields... do them at
runtime...

Tom.