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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dmg197243

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

    Average of calculated conditional field

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

    Average of calculated conditional field

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

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

Part and Inventory Search

Back
Top