Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unanswered: whats wrong with this code?

    Hours 3 Amount S: IIf((Sum(IIf([Code]="S",[RegTime],0))=0,Null,Sum(IIf([Code]="S",[RegTime],0)))>0,"S",Null)

    I didnt write it but I'm not able to find the misplaced comma.

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    You have enough arguments for 3 IIf functions, but only 2 IIf functions.
    It should read as:
    Hours 3 Amount S: IIf((Sum(IIf([Code]="S",[RegTime],0))=0,Null,Sum(IIf([Code]="S",[RegTime],0))))
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •