I have a calculated field on a report. I am trying to return the average of records filtered by 2 different criteria. I'm using the Davg function. One of the criteria is a text field and one is a number field. The formula works with one criteria but not with two. My results are either the average of the entire column or blank. Any help would be approciated
=DAvg("occrms","arr-dep","[dayof]='mon'" And "[yearof]=2012")
occrms is the field
arr-dep is the table
[dayof] is the 1st critera and a text field
[yearof] is the 2nd criteria and a number field