iff in query

[kolait]

Hello friends
I have four fields in this query. I want to count in fields five that have numbers. Thanks for helping me.

 

[theDBguy]

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

 

[kolait]

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

Hello.
No I got a regular query table

 

[theDBguy]

Hello.
No I got a regular query table

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.

 

[kolait]

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.

 

[theDBguy]

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

 

[kolait]

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

thank you.
Is that right?

 

[theDBguy]

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.

 

[kolait]

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.

 

[theDBguy]

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


tblStudents
tblLessons
tblStudentLessons
tblStudentGrades
and maybe more...

 

[kolait]

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.