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.