I have a table of student records they pay their fees in three instalments entered in the table as Payment1 Payment2 and payment3. To compute the balance paid by a student i created a calculated field that sums up all the payments and deduct from the Total course fee. I am not getting the required answer. Intead of 0 after full payment i keep getting 6 0r -6.
Also each time i create a table by entering data directly in datasheet view and i automatically assign a primary ke the numbering starts at 22 i wonder why
