anwserman
Dec 20, 2003, 01:31 PM
Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches). In the last query, for example, you were requesting those customers whose current due amount was equal to 0 (zero). If you want something other than an exact match, you must enter the appropriate comparison operator. The comparison operators are > (greater then), < (less then), >= (greater then or equal to), <= (less then or equal to), and NOT (not equal to).
EDIT: Fixed BBCode
<font size=-1>[ This Message was edited by: anwserman on 2003-12-20 10:32 ]</font>
EDIT: Fixed BBCode
<font size=-1>[ This Message was edited by: anwserman on 2003-12-20 10:32 ]</font>