DAvg Syntax with Between function

[Rickochezz]

Hello All

What I am trying to do here is find the Average Score that all students got on a Final Exam that scored X amount on a practice Exam.

Exam 1: Format(DAvg("[MSGTPExam1]","MSGTP","[Exam1] =" & [Exam1]),"Percent")

Field - MSGTPExam1
Table - MSGTP

Now if I want to open up my parameters a bit - for example if the student got a score of 64% on the Practice exam - Instead of averaging all that received 64% I would like to average all that received 62%-66% (All that scored within 2% of their score)

Exam 1: Format(DAvg("[MSGTPExam1]","MSGTP","[Exam1] =" & Between [Exam1]-.02 And [Exam1]+.02),"Percent")

This does not work? Any other ideas to accomplish my wish?

Thanks


Rick

[andy49]

Try using < and>


Sent from my iPhone using Tapatalk

[Rickochezz]

I'm sure that would work as well Andy - The problem I seem to be having is getting the syntax right

[andy49]

Expr1: DAvg("[exam1]","ID","[exam1] between " & ([EXAM1]+5) & " and " & ([EXAM1]-5))

[Rickochezz]

Thanks Andy - That is what I was looking for - works like a charm

[andy49]

No prob


Sent from my iPhone using Tapatalk