你可能感兴趣的试题
Between#92--01--01#And#92--12--31# Between"92--01--01”And"92--12--31” Between"92.01.01"And"92.12.31" #92.01.01#And#92.12.31#
"李" Not"李" lake"李" Left([姓名],1)="李"
Between #2000-01-01#And#2000-12-31# Between "2000-01-01"And"2000-12-31" Between"2000.01.01"And"2000.12.31" #2000.01.01#And #2000.12.31#
Not "仲*" Like"仲" Left([姓名],1)="仲" "仲"
Not"李," Like"李" LeO([姓名],1)= "李" "李"
“刘” Not“刘” Like“刘” Left([姓名],1)=“刘”
Between#1999-01—01#And#1999—12-31# Between"1999-01-01"And"1999—12-31" Between"1999.01.01"And"1999.12.31" #1999.01.01#And#1999.12.31#
Not“仲*” Like“仲” Left([姓名],1)“仲” “仲”
"刘" Not"刘" Like"刘" Left([姓名]1)="刘"
“刘” Not“刘*” Like“刘” Left([姓名] ,1) =“刘”
Like“教授” Left([职称],2)=“教授” “教授” 以上都对
Between#99-01-01# And # 99-12-31# Between"99-01-01"And"99-12-31" Between"99.01.01"And"99.12.31" #99.01.01# And # 99.12.31#
=Date( )-15 <Date( )-15 >Date( )-15 <=Date( )-15
Not“仲*” Like“仲” Left([姓名],1) =“仲” “仲”
Not"仲*" Like"仲" Left([姓名],1)="仲" "仲"
Between#2006-01-01And#2006-12-3l# Between”2006-01-01”And”2006.12.31” Between"2006-01-01”And"2006.12.31” #2006.01.01#And#2006.12.31#