AnsweredAssumed Answered

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

Question asked by ajseper on Mar 13, 2016
Latest reply on May 3, 2016 by 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

Outcomes