More than/Less than, equal to.......

  • Thread starter Thread starter The Insider
  • Start date Start date
T

The Insider

Guest
Could someone please tell me what symbol to use for "more than or equal to" in a query? For example, at present I use >75 when I actually need to know the code for more than or equal to 75 - any help greatly appreciated!!

Thank you.
A new user
 
You would use:

Code:
= for equal to
<> for not equal to 
> for greater than
>= for greater than or equal to
< for less than
<= for less than or equal to
Between [i]value1[/i] And [i]value2[/i] for values in a range
Like * for text comparisons with multi-character wildcards
Like ? for text comparisons with single character wildcards
 
Thanks

Thank you for your responses - much appreciated. It makes complete sense that it should be >= but as a naive user I needed some reassurance!

Regards,
Tim
 

Users who are viewing this thread

Back
Top Bottom