D
d_k_harris
Hi I am new to Access but have muddled my way through to create a
student tracking database. This database stores core information
about pupils in the main table and individual subject data in subject
tables. One of my subject tables stores scores for seperate modules
(example of field names: PupilID, Module 1 Level, Module 2 Level,
Module 3 Level, Module 4 Level, Module 5 Level, Module 6 Level,
Overall Level) I am trying to calculate an Average score to
automtically be entered into the Overall Level field from when data is
entered into the Module fields when a module is marked. I have
searched through various threads and forums and from what I can make
out Access only Averages values in a column and not across fields in a
record. My second problem is that not all module levels will be
entered at the same time. I have also read in forums that this can
cause a problem. Ideally I would like a solution so that when a
member of staff enters a score in Module 1 Level it then puts the
Average score in the Overall Level field then when Module 2 Level is
entered it adjusts the Overall Level again.
Sorry if this is a bit difficult to understand.
Any help would be greatly appreciated. Many Thanks.
student tracking database. This database stores core information
about pupils in the main table and individual subject data in subject
tables. One of my subject tables stores scores for seperate modules
(example of field names: PupilID, Module 1 Level, Module 2 Level,
Module 3 Level, Module 4 Level, Module 5 Level, Module 6 Level,
Overall Level) I am trying to calculate an Average score to
automtically be entered into the Overall Level field from when data is
entered into the Module fields when a module is marked. I have
searched through various threads and forums and from what I can make
out Access only Averages values in a column and not across fields in a
record. My second problem is that not all module levels will be
entered at the same time. I have also read in forums that this can
cause a problem. Ideally I would like a solution so that when a
member of staff enters a score in Module 1 Level it then puts the
Average score in the Overall Level field then when Module 2 Level is
entered it adjusts the Overall Level again.
Sorry if this is a bit difficult to understand.
Any help would be greatly appreciated. Many Thanks.