Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Unanswered: Access Counting multiple columns with Y value

    I am new to using Access SQL statements. After hours of attempts, I either get erroneous results, or unresolved SYNTAX errors. Hopefully, someone can help me resolve the following problem:

    In an SQL statement, I have a table that I would like to obtain the sum for "each" of three columns based on a certain value within a group. Example: For each Region, I would like to know the total sum for column-2 when a "Y" value is found, the total sum for column-3 when a "Y' value is found, and the total sum for column-4 when a "Y" value is found.

    TBL-RegionValidation - table name
    Region - column1
    ProductFlagged - column2
    ProductValidated - column3
    ProductRemoved - column4

    Your assistance would be greatly appreciate!

  2. #2
    Join Date
    Sep 2012
    Never mind, after lots of trial and error, I finally figured it out! Thx anyway. -Tim

Posting Permissions

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