Re: Working with formulas...new post!!!
- From: "Linq Adams via AccessMonster.com" <u28780@uwe>
- Date: Tue, 02 Oct 2007 12:37:09 GMT
Actually, if the calculated value is dependent on the current exchange rate
(which the question sort of sounds like) then this may be one of the cases
where storing the result is warrented. Recalculaing it at a later date when
the exchange rate has changed would not give accurate results. You could, of
course, go thru the dog and pony show of having another table to track the
historical exchange rates and so forth, but in this day of gazillion gigabyte
hard drives it seems like overkill to avoid stoing a few calculated results.
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200710/1
.
- References:
- Working with formulas...new post!!!
- From: ANGELICA
- Re: Working with formulas...new post!!!
- From: Jeff Boyce
- Working with formulas...new post!!!
- Prev by Date: RE: Record Form
- Next by Date: RE: Record Form
- Previous by thread: Re: Working with formulas...new post!!!
- Next by thread: Re: Help with creating / merging cover sheets using Access and Wor
- Index(es):