4 Replies Latest reply on Mar 17, 2014 10:38 AM by dawson345

    Retrieving a value based on Three Variables




      I have set up a database which includes a survey form for Solar PV installations. I need to retrieve a value based upon three factors (Postcode Zone, Orientation and pitch) I have placed the data in a table with the following format:




      Postcode ZoneSlopeOrentation Zero DegreesOrentation Five Degrees (etc.)
      Zone 10776546
      Zone 11678678

      Zone 20678654



      I am happy to change the way this is stored, the original file is here - Irradiance Datasets


      I have the three search terms ready but I am having trouble finding the feature to search and retrieve the value required for my calculation.


      Please help!