This topic has been archived. It cannot be replied.
-
枫下家园 / 电脑用户 / Can anybody help me about Access query or SQL? Thanks1. what constant means "empty date". I mean a date type field that hasn't been input yet. I tried "NULL" and "#00/00/00#" and "0". They don't work.
2. How can I realize multi conditions in SQL or Access query?
For example, there are 3 fields. field1,field2,field3
I want to realize:
IF field3 isn't empty
{
IF field3-field1>7
list field1, field2, field3, field3-field1
}
ELSE
{
IF field2-field1>7
list field1, field2,field3, field2-field1
}
Thanks!
-hiding(HHHHH);
2002-7-25
{495}
(#657068@0)
-
好象是这样的1.empty date 大概英文意思的null,但你不能输入null,要在sql中 set field***=null
2.本人好象用一句sql完成不了,用几句还行
-oceandeep(鱼尾巴);
2002-7-25
{119}
(#657078@0)
-
Thanks.
1. I used "SELECT ..... WHILE field*=null", it doesn't work.
2. can I use several SQL in Access query?
-hiding(HHHHH);
2002-7-25
(#657420@0)
-
in my system. the first should be----where field*** is null. 2.i know nothing about access, but i think of course u can
-oceandeep(鱼尾巴);
2002-7-25
(#657568@0)
-
Thank you very much. I'll try tommorow.
-hiding(HHHHH);
2002-7-26
(#659363@0)