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

    Retrieving a value based on Three Variables

    dawson345

      Hello,

       

      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!