For the Range, and assuming your numbers are numeric rather than alpha,
Fieldname <700 .or. Fieldname >=800
should do it.
If the field is alpha but can be treated as a numeric range convert to numeric first.
Val(Fieldname) <700 .or. val(Fieldname)>=800
If the filter get more complicated than that consider creating each filter in a simple form and then using the simple filters to create a Compound filter or a compound of compound filters to bring them all together.
If you have lists of values to include or exclude you can also use the .IN. and .NotIn. operators in the filter definition tool.