getting average

[yiega]

hi guys,okay i have created a database and i cants seem to get the average of what i want correctly.
so to make things simple i have one table having a studentID field,Maths,English,French and Science Fields, the subjects fields should contain the marks of each studentID e.g StudentID 1,Maths 20,English 30,French 40,Science 60....studentID 2,Maths 30,English 60 and so on...i made a query which would give me the average of the each studentID subject total marks, the query was like this
total avergae: ([Maths]+[English]+[French]+[Science])/4..


the query worked but there was a catch to my design like perhaps a student dint do one subject,his avergae will not show!!what i want is that even if a student dint do a subject i want his avergae to show i.e is if even if i do not fill a subject mark,an automatic 0 should be there!is this possible?thanks

[June7]

Use Nz() function:

(Nz([Maths],0)+Nz([English],0)+Nz([French],0)+Nz([Science],0))/4

[yiega]

wow!!thanks june 7.tried the nz query and it worked out great.thanks alot !!!!