ä½ è¿ä¸ªæ¥æ é¦å
åå
¥accessæ¶è¿è¡è½¬æ¢å°±å¥½äº
å¦å¤ä½ ççä¸é¢çæ¹æ³
â
ææ¥è¯¢æ¶çåformatï¼å³ï¼
riqi=format(riqi,"mm/dd/yyyy")
æ
riqi=format(riqi,"dd/mm/yyyy")
以åè¿æ¯æä½ ç¨çè¯å¥ååºæ¥å§ï¼è¿ä¹ä¸ååºæ¥ï¼å°±ç¥éé®é¢å¨åªéäº
vbç¨sqlè¯å¥æ¶ï¼ç¨ä»¥ä¸æ¹å¼å³å¯
sql="SELECT * FROM E where e.data>=#" & format(riqi,"dd-mm-yyyy") & "#"
æ
sql="SELECT * FROM E where e.data>=#" & format(riqi,"dd/mm/yyyy") & "#"
ä½ ç
SELECT * FORM E where e.data>='"& format(riqi,"dd-mm-yyyy")&"'
åªæ¯accessçsqlè§å¾è¯å¥æ
â
http://zhidao.baidu.com/question/106792285.html