Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2014

    Angry Unanswered: Calculations with values in previous record(s)

    I have a database where I need to record student data, specifically marks and absenteeism. The marks are recorded each term as a running total. I have a final mark which needs to be equal to the 4th term mark.

    I also need to record the number of days absent each term with a total at the end of the year.

    My problem is that the term 4 mark is a in the previous record and the total days absent needs to be the total of the previous 4 records (term 1 - 4).

    I using a create table query and an update query but that was a no go.
    Attached Files Attached Files

Posting Permissions

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