Davg Multiple Criteria Syntax

[JonathanT]

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

[JonathanT]

I was able to figure out the correct syntax. I had extra quote marks that I didn't need. Her is the corrected syntax
=DAvg("occrms","arr-dep","[dayof]='mon' And [yearof]=2012")