I have a monthly report that I would like to run that averages results if they are from the same day. Is this possible?
Collect Result Average
Date
1/2/17 1
1/2/17 3 2
1/3/17 4
1/4/17 1
1/5/17 6
1/5/17 6 6
I am having trouble using the following code in a query. I keep getting an #error can someone please help me out?
Myresult: nz(iif([result]<[RDL],"<"&[RDL],[result]),"NA")