在Ms Access查询中没有执行 [英] in Ms Access query is not executing
问题描述
设计中的数据库如下;
Sch_Date datetime
会话编号
课程文本
Faculty_Code text
select * from Tb_SCh_TIme_Table;
$ b检索到数据库结果的$ b它工作正常。
Sch_Date会话课程Faculty_Code
23 / 1/2013 1 REO GS
23/1/2013 2 PH2 Vb
23/1/2013 3 TASCO CK
24/1 / 2013 1 CTF SJ
从Tb_SCh_TIme_Table中选择Sch_Date,Session,Course,Faculty_Code,其中Session =''1';
当我执行以下查询时,错误显示标准表达式中的数据类型不匹配。
以下结果未来。
23/1/2013 1 REO GS
24/1/2013 1 CTF SJ
从Tb_SCh_TIme_Table中选择Sch_Date,Session,Course,Faculty_Code,其中Session =''1';
试试这个
你写错了查询。试试这个
选择 Sch_Date,Session,Course,Faculty_Code 来自 Tb_SCh_TIme_Table 其中会话= 1
Database in design a s follows;
Sch_Date datetime
Session number
Course text
Faculty_Code text
select * from Tb_SCh_TIme_Table;
from the database results are retrieved it is working fine.
Sch_Date Session Course Faculty_Code
23/1/2013 1 REO GS
23/1/2013 2 PH2 Vb
23/1/2013 3 TASCO CK
24/1/2013 1 CTF SJ
select Sch_Date,Session,Course,Faculty_Code,from Tb_SCh_TIme_Table where Session=''1'';
when i execute the below query error shows Data Type mismatch in criteria expression.
the below results is not coming.
23/1/2013 1 REO GS
24/1/2013 1 CTF SJ
select Sch_Date,Session,Course,Faculty_Code from Tb_SCh_TIme_Table where Session=''1'';
try this
you have write wrong query. try this
select Sch_Date, Session, Course, Faculty_Code from Tb_SCh_TIme_Table where Session=1
这篇关于在Ms Access查询中没有执行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!