Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    2

    Unanswered: Simple report query

    I have this expression in a report;

    =Sum([Supplier Status]="Unknown")*-1

    Which tells me I have 84 suppliers that are Unknown status;

    =Sum([Sales]) Gives me the total sales (For all).

    Now then, how do I combine the two into 1 expression so that I display the total Sum for just the 84 supplier's?

    I can't get my head round it.

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    =Sum(iif([Supplier Status]="Unknown",[Sales],0))

  3. #3
    Join Date
    Mar 2002
    Posts
    2
    Originally posted by PracticalProgram
    =Sum(iif([Supplier Status]="Unknown",[Sales],0))
    Thank you very much.

    Joe

Posting Permissions

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