I'm relatively new to Microsoft Access, but I have a bit of SQL experience. I have a very specific question regarding a calculated field I would need in one of my tables
The field InstrumentReturn from table t_instrument_return should be the current InstrumentPrice divided by the previous InstrumentPrice minus 1 (table= t_instrument_price). Note that each day for each instrument only one price is stored (the id is instrumentID) but that there are multiple instruments for which price info is stored on a single day. So for each of these instruments the InstrumentReturn should be calculated, based on the price info of that particular instrument
Is this possible to calculate via calculated fields? If yes, how? Is this an appropriate method or do you advice me something else?
Cheers