4 Replies Latest reply on Feb 25, 2012 12:44 PM by ArthurJoyce

    Use of record field not in found group for a calculation

    ArthurJoyce

      Title

      Use of record field not in found group for a calculation

      Post

      I have a calculation field where I'm trying to get a date field from the last record of the total database and then using that field date in a found group of records. My present line of the calculation is:

      end = GetNthRecord ( mydatefield ;  Get (TotalRecordCount) ) ;

      I found that the calculation works great as long as all the records are being displayed. There are 1700 records in the database. However, as soon as I find a group of 400 records, the calculation field doesn't show anything at all.

      The database changes weekly and I need a specific date from the last record created in order to do what I want to do when I find a subset of the database.

      Any help is greatly appreciated.

      Arthur Joyce