Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA to access AS400 - ConnList comes back as zero
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...- dmg197243
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
-
Average of calculated conditional field
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...- dmg197243
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
