I need to create a columns to calculate my records totals

[Guest]

I am new at access so please bear with me...
I have been asked to create a database at my job and this database contains
student information ex. name, address, phone, fees dues spring, fees due
fall, etc.
My question is how do I get my table to total for each individual student
for amount owed? example if a student owes $10 for spring, $5 fall, $20 for
winter I would like it to total $35 and when they pay fees how do i get the
table to subtract to show correct amount left owing? I have my table, query,
form and reports designed but can't figure out how to get each student record
to have its own total. Thanks in advance for your help.

 

[Joseph Meehan]

I am new at access so please bear with me...
I have been asked to create a database at my job and this database
contains student information ex. name, address, phone, fees dues
spring, fees due fall, etc.
My question is how do I get my table to total for each individual
student for amount owed? example if a student owes $10 for spring,
$5 fall, $20 for winter I would like it to total $35 and when they
pay fees how do i get the table to subtract to show correct amount
left owing? I have my table, query, form and reports designed but
can't figure out how to get each student record to have its own
total. Thanks in advance for your help.

Tables just store information in a bucket along with the definitions of
the fields. They don't do calculations. They don't even keep the
information in any kind of order.

Your first and most important thing is to build the table design
properly.

I would guess you will need at least two tables. On for students
listing the student demographics and one for fees.

Once you do this, you are a lot closer to getting your answer.

Access is a relational database, it is not a spreadsheet so you need to
start thinking in terms database not spreadsheet.

If you do not have two tables, and if your table repeats student
information, let's start there.

If you do have your tables set up properly, let's see the design that
you are using and we likely can help from there.