Search results for query: *

I am writing some VBA code to read values from an excel file, put those values into an AS400 window and then scrape some values off that AS400 window. I am using VBA 6.0, and IBM Iseries Access for Windows (PCOMM) v5.7. My code, so far, is as follows: Public Sub TestRoutine() Dim PS As...

Thanks. The first statement is in the report and it does work (the typo was just a typo in this thread, not in the actual code). It is when I try to put a field in the footer that does the Avg(... first statement...) that returns the "expression too complex" message.

Thanks. When I put it in the query all I get returned is an "#Error" for the value. If I remove the conditions and just put in something like "[BREAK]-1800" then it works in either the query or the report. For some reason Access 2003 doesn't seem to like doing an AVG (or SUM or any aggregate...

I have a calculated field on the detail level of a report which is calculated as follows: =Iif([BREAK]>1200 AND [LUNCH]<>0),1800-[BREAK],IIF([BREAK]<>0,900-[BREAK],0)) This calculates correctly, however when I put the following calculated field in the Group footer section of the report, I...