3 Replies Latest reply on Nov 10, 2016 6:50 PM by Sherzodbek Ibragimov

    one database table in Excel-Style. How to sum this?

    Thorsten Lieder

      Hello,

       

      I use a database file (Access) where the most tables are normalized.

      BUT one table includes values I need as a sum of rows :-(

       

      The table is like this:

       

       

      IDregionyearvalue_1value_2value_3value_4value_5value_6value_7value_8value_9value_10value_11value_12
      5BERLIN2014222021202020232122222021
      25BERLIN2015212022201822232122222122
      45BERLIN2016202121212022212322202221
      65BERLIN2017222023182121212321202219

       

      With created parameters (also used for other operations) I read the year and the month-from and month-to

      (here the month-values are in value_1 to _12

       

      The job is to sum for example region = Berlin, year = 2015, month-from = 3 (mar) to month-to = 9 (sept)  (from value_3 to value_9)

      SORRY, it's a access-table, connected to other tables a well, I can NOT pivot it.

       

      Does anybody have an idea how to summarize this with a function or a created field???

       

      Thank you!!!