Results 1 to 2 of 2
  1. #1
    wijo85 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2017
    Posts
    3

    Calculated Field - value calculated based on 2 values in another tables

    Click image for larger version. 
<br /><script async src=
    Name: db_structure.JPG  Views: 7  Size: 61.4 KB  ID: 28780" class="thumbnail" style="float:CONFIG" />


    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

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,049
    Do you really need to store this in a table?

    Calculation fields are usually carried out in a query or even form/report level

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 25
    Last Post: 11-23-2014, 02:43 PM
  2. Test String test besed on table data
    By igourine in forum Programming
    Replies: 3
    Last Post: 12-01-2013, 06:16 AM
  3. Lab Test and Parameters ERD
    By cap.zadi in forum Database Design
    Replies: 3
    Last Post: 11-14-2012, 09:29 AM
  4. Test
    By goatamus in forum Access
    Replies: 1
    Last Post: 02-02-2012, 02:44 PM
  5. Keying in Test answers to Access DB from Written Test
    By CityOfKalamazoo in forum Access
    Replies: 3
    Last Post: 03-01-2010, 08:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums