Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Preston, Lancashire, UK
    Posts
    26

    Unanswered: IF statement in query criteria

    Hi
    I have a table which contains a Category, Sub Category, Supplier and Suppliers spend, with a cumulative percentage field [CP] which describes what % a particular suppliers spend is of the Sub Category total, I want to display the supplier records where the [CP] is 80% or less of the Sub Category spend, Grouped by the Category, easy enough, criteria for the [CP] <=80
    Problem is, some of the Sub Categories only have 1 or 2 suppliers, so all the suppliers [CP] is greater than 80% and therefore no supplier records are displayed for that Sub Category.

    Is it possible to add the criteria with an if statement, if all records >80 output ALL else output records <=80?

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Preston, Lancashire, UK
    Posts
    26
    All Sorted, not sure how close this....

Posting Permissions

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