Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2012
    Posts
    23

    Unanswered: Changing a calculation into a fixed figure

    Hi - I have a form within BDB that carries out nearly 300 calculations for each record, this only applies to one financial year. The totals are then carried forward to the next year where another 300 calculations are made.

    As the years roll forward so do the number of calculations, and the current is therefore dependant on the all the previous years calculations.

    Is there anyway of fixing the totals from a previous year so that they can be discarded, reducing the size of the database and the dependency on keeping all the previous years data.

    Many thanks
    Paul

  2. #2
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Not sure if have a handle your setup but is it possible to transfer your totals to a dedicated form (table) with a reference id and then delete the old data?
    Provided you have a key to identify these totals, they then could be related to new data set for next year.

    Regards
    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •