Such as elected student id=1203 language result, which is 76, and to assign the value to a variable

Use the select * from sheet1 where student id=1203, Chinese,,,
Try some or not
Also considered group by

CodePudding user response:

Select the language from sheet1 where student id=1203

Then take adoquery1. Fields [0]. Asstring