主题：考场安排：这个座位公式错在哪里？

在“学生成绩表中”的“座号”列的公式，怎么写，我的意图是：把“考场安排”中相应的学生姓名，对应到“学生成绩表”中“座号”列中，并在“座号”列中填入这个学生应该在“哪场哪列”，现在这个公式不对，不知错在哪里了，请版主改一下。egd文件下载


-=-=-=- 以下内容由 hbfnmxb 在 2009年11月20日 05:19pm 时添加 -=-=-=-
“哪场哪列哪行”

if(FindRow("考场安排","第一列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第一列_姓名","=",[姓名])+" 第1列 "+FindText("考场安排","行号","第一列_姓名","=",[姓名]),"")

帮你做了判断一列的公式，你自己可以一列一列判断，结果直接用加号连接下去即可。

if(FindRow("考场安排","第一列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第一列_姓名","=",[姓名])+" 第1列 "+FindText("考场安排","行号","第一列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第二列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第二列_姓名","=",[姓名])+" 第2列 "+FindText("考场安排","行号","第二列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第三列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第三列_姓名","=",[姓名])+" 第3列 "+FindText("考场安排","行号","第三列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第四列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第四列_姓名","=",[姓名])+" 第4列 "+FindText("考场安排","行号","第四列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第五列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第五列_姓名","=",[姓名])+" 第5列 "+FindText("考场安排","行号","第五列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第六列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第六列_姓名","=",[姓名])+" 第6列 "+FindText("考场安排","行号","第六列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第七列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第七列_姓名","=",[姓名])+" 第7列 "+FindText("考场安排","行号","第七列_姓名","=",[姓名]),"")

写成功了

但是重名的就有点麻烦了,1班有一个叫"周杉"的在第六场,16班也有一个叫"周杉"的,在18场,后面的"座号显示了他们所在的两场的声号,怎样解决这个重名的问题,请CZy版再看看,谢谢!!

是您的思路的问题，为什么不用考号？要用姓名？两者在解决重复的问题上差别很大。

是在要用姓名，那就在排座时每个姓名前加上班级。

我的思路：在现在的基础上能不能再加上一个对“班级”的判断，如果可以，怎样写这个公式。

直接加个比较条件不就ok了

if(FindRow("考场安排","第一列_姓名","=",[姓名],"第一列_班级","=",[班级])>0,FindText("考场安排","考场号","第一列_姓名","=",[姓名],"第一列_班级","=",[班级])+" 第1列 "+FindText("考场安排","行号","第一列_姓名","=",[姓名],"第一列_班级","=",[班级]),"")

我试试

-=-=-=- 以下内容由 hbfnmxb 在 2009年11月23日 10:45am 时添加 -=-=-=-
if(FindRow("考场安排","第一列_姓名","=",[姓名],"第一列_班级","=",[班级])>0,FindText("考场安排","考场号","第一列_姓名","=",[姓名],"第一列_班级","=",[班级])+" 第1列 "+FindText("考场安排","行号","第一列_姓名","=",[姓名],"第一列_班级","=",[班级]),"")+
if(FindRow("考场安排","第二列_姓名","=",[姓名],"第二列_班级","=",[班级])>0,FindText("考场安排","考场号","第二列_姓名","=",[姓名],"第二列_班级","=",[班级])+" 第2列 "+FindText("考场安排","行号","第二列_姓名","=",[姓名],"第二列_班级","=",[班级]),"")+
if(FindRow("考场安排","第三列_姓名","=",[姓名],"第三列_班级","=",[班级])>0,FindText("考场安排","考场号","第三列_姓名","=",[姓名],"第三列_班级","=",[班级])+" 第3列 "+FindText("考场安排","行号","第三列_姓名","=",[姓名],"第三列_班级","=",[班级]),"")+
if(FindRow("考场安排","第四列_姓名","=",[姓名],"第四列_班级","=",[班级])>0,FindText("考场安排","考场号","第四列_姓名","=",[姓名],"第四列_班级","=",[班级])+" 第4列 "+FindText("考场安排","行号","第四列_姓名","=",[姓名],"第四列_班级","=",[班级]),"")+
if(FindRow("考场安排","第五列_姓名","=",[姓名],"第五列_班级","=",[班级])>0,FindText("考场安排","考场号","第五列_姓名","=",[姓名],"第五列_班级","=",[班级])+" 第5列 "+FindText("考场安排","行号","第五列_姓名","=",[姓名],"第五列_班级","=",[班级]),"")+
if(FindRow("考场安排","第六列_姓名","=",[姓名],"第六列_班级","=",[班级])>0,FindText("考场安排","考场号","第六列_姓名","=",[姓名],"第六列_班级","=",[班级])+" 第6列 "+FindText("考场安排","行号","第六列_姓名","=",[姓名],"第六列_班级","=",[班级]),"")+
if(FindRow("考场安排","第七列_姓名","=",[姓名],"第七列_班级","=",[班级])>0,FindText("考场安排","考场号","第七列_姓名","=",[姓名],"第七列_班级","=",[班级])+" 第7列 "+FindText("考场安排","行号","第七列_姓名","=",[姓名],"第七列_班级","=",[班级]),"")

成功，谢谢！！

应该用学号进行判断，不然你的系统会杂乱无章。