Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi everyone!

    Can you please, help me with dilemma.

    I am replicating Report in Access that was previously done in Crystal.
    Crystal has ability to calculate totals by row and by column.
    I am not sure Access has the same, so here is the problem - last summary page data looks like following:

    ID_______Prod1___Prod2___Prod3___Total
    11_________5_______6_______7______18
    12_________6_______6_______7______19
    13_________5_______7_______8______20

    I have calculated totals:

    Total_____16______19______22__GT:__57

    *************************************

    The problem is now I need to have percentage of

    Prod1/Total of Prod1 - 5/16, Prod2/Total of Prod2 - 6/16 etc
    also
    Prod1/GT - 5/57, Prod/GT - 6/57 etc

    for each Prod and ID. I am trying SUBs etc. but I can't figure out how to keep Grand Total to divide by.


    Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='MS_fan' post='767576' date='26-Mar-2009 15:27']The problem is now I need to have percentage of

    Prod1/Total of Prod1 - 5/16, Prod2/Total of Prod2 - 6/16 etc
    also
    Prod1/GT - 5/57, Prod/GT - 6/57 etc

    for each Prod and ID. I am trying SUBs etc. but I can't figure out how to keep Grand Total to divide by.[/quote]
    In attachment a database sample. See in query SumByRow if you have all the values you want.
    [attachment=83086:db1.zip]
    Attached Files Attached Files
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Francois!
    It seems like it is all I need! I will have to take a beter look but I see numbers I need.

    Thanks so much for your time and help and have a great day!

Posting Permissions

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