5 Replies Latest reply on May 3, 2016 7:23 PM by ajseper

    For a Record with a known field how do I find another field in the same record

    ajseper

      I built a stock quote tracking db with two tables an Equity and a Quote table. Included are date filtered tables of Quote Occurrences from which I require the quote for a particular date to be used to calculate a percent change. What Function should I be using to get a Quote for a particular date? I tried using the "GetNthRecord(FieldName;RecordNumber)". This works so long as the data is entered sequentially. Any rogue data entry messes thing up.

      Would using a Script be a better approach?

       

      Any help appreciated.

       

      Thanks

       

      Al Seper