Calculated field

M

MelanieZ

Hi there, I am a newbie to access so i'm sorry if this seems really basic.

I am a teacher and I am trying to input a final mark for 20 individual
assignments. What I would like to do is to have a field at the end that
totals up the individual's mark. How do I go about doing that?

Thanks,
 
S

Steve Schapel

Melanie,

You would do this calculation in a Query.

Let's suppose the fields in your table are like this...
Student
Assignment
Mark

Then you would do like this...
1. Make a query based on this table
2. Add the Student and Mark fields to the query design grid
3. Change it to a Totals Query (select Totals from the View menu in
Design view of the query)
4. In the Totals row, enter Sum
5. Run the query (click the toolbar button with the red [!] icon

This should show you the total mark for each student.

If you need more help with this, please post back with further details,
and example, of your tables and data.
 
Top