PDA

View Full Version : Using Comparison Operators


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>
Dime
Dec 20, 2003, 01:34 PM
I WANNA BE LIKE MIKE
s.TiNgEr
Dec 20, 2003, 01:34 PM
Even if I understood a fucking word you just said, I probably wouldn't care anyway
anwserman
Dec 20, 2003, 01:35 PM
Its from a stupid book from college!
s.TiNgEr
Dec 20, 2003, 01:37 PM
On 2003-12-20 10:35, anwserman wrote:
Its from a stupid book from college!


Figures
Maverynthia
Dec 20, 2003, 11:46 PM
due amount =>$1