Is that a Crosstab query? If so, add a Sum() column.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Sounds like you may have a bad table structure then. In that case, you may have to manually do it. For example:

Total: Field1 + Field2 + Field3 + Field4, etc.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Sounds like you may have a bad table structure then. In that case, you may have to manually do it. For example:

Total: Field1 + Field2 + Field3 + Field4, etc.

223/5000
I want to give the students a score.
Up to four points in one day.
I made a table containing five fields:
Student Code
Date of Registration
Score one
Score two
Score three
Score four
I want to get an average for every student
But the average scores have numbers.

223/5000
I want to give the students a score.
Up to four points in one day.
I made a table containing five fields:
Student Code
Date of Registration
Score one
Score two
Score three
Score four
I want to get an average for every student
But the average scores have numbers.

Yeah, definitely not a recommended table structure. A proper design would probably be more like:

tblStudents
StudentCode, PK
RegistrationDate

tblScores
ScoreID, PK
StudentCode, FK
Score

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Looks right. If you need to identify each score, then you need to add one more field to help you do that. For example, maybe a DateGiven or DateEarned or SubjectID, etc.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Looks right. If you need to identify each score, then you need to add one more field to help you do that. For example, maybe a DateGiven or DateEarned or SubjectID, etc.

Yes
I also need lesson specifications and tutorials ..
I do and ask.
Thank you for taking the time for me.

Hi. If this is for a student grade tracking database, you might need tables like:

tblStudents
tblLessons
tblStudentLessons
tblStudentGrades
and maybe more...

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Hi. If this is for a student grade tracking database, you might need tables like:

tblStudents
tblLessons
tblStudentLessons
tblStudentGrades
and maybe more...

Hello
In a table, I have four field scores. I want to find them in a mean field.
Calculate the mean if they have scores. For example, if two fields are scores, divide the sum by two.
If three of the four fields are scored, the average of the three scores is calculated.
Thanks for helping me.