Search results

Working SQL with the DLookup SELECT QueryNPSumField.Field, QueryNPSumField.SoilType, QueryNPSumField.TableCropN, QueryNPSumField.TableSNSRain, DLookUp([SoilType],'SNSRainfall',[Crop]=[TableSNSRain]) AS SNSNumber, [TableCropN] & [SoilType] AS Ntype FROM QueryNPSumField INNER JOIN SNSRainfall ON...

Hi I am trying to do another DLookup in my query, using a First DLookup result as the 2nd's field name. I will post the code hopefully to explain better. 1st Dlookup, this returns a number from 0 to 5, which is working. SNSIndex: DLookUp([SoilType],[TableName]) 2nd DLookup, not working...