Is there a reason I get no results in the date field using this statement for my criteria? I'm guessing something is wrong with my expression DatePart("d",date())=1
IIf(DatePart("d",Date())=1,>=DateSerial(Year(Date()),Month(Date())-1,1) And <Date(),>=DateSerial(Year(Date()),Month(Date()),1)...