Search results

I am trying to count records based on multiple criteria in the report footer in an unbound text box. I get an error that the expression is too complicated. Please advise Sum(IIF([txtField1] = "value1" And [txtField2] = "value2",1,0)) Sum(IIF([txtField1] = "value1" Or [txtField2] = "value2"...

I have a Date/Time field that I am trying to sort by using: Between[Enter The Date] And [Enter The Date] I would like the user to specify a date (mm/dd/yyyy) and time range in 24hr time (HHMM). The criteria entered may be on the same day, it may overlap the next day. I am new to Access and...