Search results

  1. A

    Averaging value if the date is the same

    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
  2. A

    Issue with if statement using multiple criteria

    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")
Top Bottom