I am trying to create a report that counts all practices based on the range of the survey score they have given us. For example,
Score 8-10
Score 5-7
Score 1-4
in the first text field for score 8-10 I am able to get it to work properly. I came up with =DCount("[Score]","QCS","[Score] >= 8")
for the score range for 5-7 I have used =DCount("[Score]","QCS","[Score] >=5 And <8") but getting #Error.
I am not sure if i am missing something like single quotes or extra parentheses or both.
Can someone help me please?
Thanks in Advance