Recent content by JayDubya

Yes, I have an = sign at the beginning. I have it in the report footer, is there any other settings I might be missing? When I move it to the Page Footer, I get #Error, but the report will print. When I put it in the report footer (where I need it), I get the error 3071 (Expression is typed...

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"...

Thanks! I will check it out.

I understand what you are saying. I am trying to do this in the query criteria to prevent having to train 200 people on a new method. The criteria I had was working just fine for a week until someone tried to run a report across the 24hr period into the next day.

Thanks, but I have a form that is used to enter data on the table. The query is for a report that needs to be run only a few times a day. The problem I have is that the query needs to be a 4 hr period sometimes and other times it could be a 7 1/2 day period.

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