dawson345

Retrieving a value based on Three Variables

Discussion created by dawson345 on Mar 12, 2014
Latest reply on Mar 17, 2014 by 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!

Outcomes