Hi, I am not quite sure I understand what you are asking but in Excel you could use a “round up” function. Then perhaps use this rounded up number to do a vlookup on a table having the next higher up value? Not sure how to do that in Access.
Not sure how or if you can do that in QGIS... I would need to see actual problem i think to be able to fully understand it. Nicolas > Le 2 nov. 2018 à 21:28, Francois Chartier <fra.chart...@gmail.com> a écrit : > > Hi, > > I am using Microsoft Access to populate a data set at regular intervals along > the vertical axis between two elevation ranges (50 to 350 masl) and have the > attribute (which does not exist) of that elevation to become the attribute of > the above data point. example at 124.4, attribute at location 1 is A, > therefore at 124 attribute becomes A, and this down to the next data point at > example 121.6 masl where it is B (you will at location 1: at 124=A, 123=A, > 122=A). > The goal being to interpolate different elevation slices at regular intervals > as data points are not all at the same elevations depending on location. > I am able to do this with a Cross Join query in access and then removing any > intervals above top and bottom. this is quite fastiduous, and i am wondering > if i can do this straight in qgis, or > if i can run an interpolation with a condition that the value at location x,y > equals the next above attribute value. this would keep the attribute table > much smaller. > > thanks > F > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
