Criteria in Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
i haven't been to newsgroups in a while, but a lot has changed! Anyway, i
have a field in a query which contains numbers ranging from -100 to 100. I
would like to filter out some of the numbers. For instance, i would like to
exclude 0 and any numbers greater than 8. How can i go about doing this in
the criteria of the query or any other method.

Thanks,
Rob
 
Back
Top