access多條件多字段查詢?
dim x
x="where id="&id
單一條件查詢
sql="delete * from phone "&x
多條件(假設字段為a、b、c、d)查詢,id不為空
if a"" then x=x& and a="&a
if b"" then x=x& and b="&b
if c"" then x=x& and c="&c
sql="delete * from phone "&x
上一篇計算機二級考試前
下一篇如何關閉steam防火墻
access多條件多字段查詢?
dim x
x="where id="&id
單一條件查詢
sql="delete * from phone "&x
多條件(假設字段為a、b、c、d)查詢,id不為空
if a"" then x=x& and a="&a
if b"" then x=x& and b="&b
if c"" then x=x& and c="&c
sql="delete * from phone "&x