Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: Access 2k, filtering question.

    Hoping someone out there can help me with this one. here is my situation.

    I have 3 fields

    field 1 = customer number
    field 2 = a numeric variable (Amount purchased if you will)
    field 3 = 3 variables A, B, or C

    A= Apples
    B= Pears
    C= Oranges

    Customer 1 1 A
    Customer 2 5 B
    Customer 2 7 C
    Customer 3 3 B

    In Field 3, given that in any row I can have either an A, B, or C I need to have, either via query or report, a way of filtering into a report that will list say Customer 2 as having purchased a total of 5 pears and 7 Oranges.

    I hope that makes proper sense, I am still learning this package and I appreciate any help given ahead of time

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Set a grouping level for you report to field 1.

    Then you can set three combo boxes in the footer of the grouping level to:

    =SUM(iif([column 3] = "A", 1, 0))
    =SUM(iif([column 3] = "B", 1, 0))
    =SUM(iif([column 3] = "C", 1, 0))

  3. #3
    Join Date
    Mar 2004
    Posts
    56
    Thank you kindly, but I dont understand what you mean by set a grouping level?

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I see... you may want to pick up a beginners book if you want to get the most out of access. It's a bit difficult if you have zero exposrue at all.

  5. #5
    Join Date
    Mar 2004
    Posts
    56

    Talking

    I am sorry, its been a very long time for me but remembered 3 mins after reading it a few times to jar the ole memory, I did as you suggested and it works great!

    Now I just need to get the format as for output. Thanks much for your patients

Posting Permissions

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