Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015
    Posts
    1

    Unanswered: need help to match the sum of column values to another table

    Hi,

    I am using access 2010. I have "classlevel" table with 2 columns-Class and Value1 .Value1 column has numeric values that i ll input from webpage (webpage to ms access connectivity).

    I want to sum the values of column "Value1" and i have another table-"Volume" which has 2 columns "VolumeLevel" and "Value2". So i want to match the sum that i calculated from first table-"ClassLevel" with the "value2" column in "Volume" table and get the corresponding "volumelevel" column value from that table and there is a third table that will get this volumelevel value.

    There is no common column to join these tables.

    Classlevel-


    Class Value1
    Class 0 3000
    Class 1 2000
    Class 2 300
    Class 3 400
    Class 4 500




    Volume-


    Volumnlevel Value2
    Vo 0
    V1 5000
    V2 10000
    V3 30000
    ....upto V10




    Answer that i am looking for is V1 as sum=6200 lies between 5000 and 10000 so its V1.


    Table 3-


    Volume-
    V1




    Please help on how will i get the third table value.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    answered on the other board.

Tags for this Thread

Posting Permissions

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