問題：窗體中有一組合框用于確定關(guān)系（<、>、=），有一文本框用于確定數(shù)值，如何在查詢中定義條件，查詢滿足由組合框和文本框組成的條件的數(shù)據(jù),如:金額>100或<500等。
解決方案
SELECT *
FROM 表1
WHERE fa between iif(forms!窗體2!fh="<",0,iif(forms!窗體2!fh="=",forms!窗體2!sz,forms!窗體2!sz+0.1^9)) and iif(forms!窗體2!fh=">",9^99,iif(forms!窗體2!fh="=",forms!窗體2!sz,forms!窗體2!sz-0.1^9));
解決方案
SELECT *
FROM 表1
WHERE fa between iif(forms!窗體2!fh="<",0,iif(forms!窗體2!fh="=",forms!窗體2!sz,forms!窗體2!sz+0.1^9)) and iif(forms!窗體2!fh=">",9^99,iif(forms!窗體2!fh="=",forms!窗體2!sz,forms!窗體2!sz-0.1^9));