Filtering with two variables

[Guest]

I am filtering a database with 4 columns. Movie title, Rating, number of
votes, and overall rank. I am attempting to filter the original table, to
show data that meets the following variables. The fist is i only want to
show entries with a rating of 8 or greater. I know how to do this. I used
the expression [rating]>=8..... Now for the hard part. The other filter I
want to use with this query is to show only the movies that start with M or
N. I have been trying everything I can think of and nothing works. Please
Help

Thank you in advance

 

[John Vinson]

I am filtering a database with 4 columns.

Jargon alert: a Database is the .mdb file, a container for multiple
tables, forms, and other objects. You're filtering a Table.

Movie title, Rating, number of
votes, and overall rank. I am attempting to filter the original table, to
show data that meets the following variables. The fist is i only want to
show entries with a rating of 8 or greater. I know how to do this. I used
the expression [rating]>=8..... Now for the hard part. The other filter I
want to use with this query is to show only the movies that start with M or
N. I have been trying everything I can think of and nothing works. Please
Help

Thank you in advance

Use a criterion on the Title such as:

LIKE "[MN]*"

or

BETWEEN "M" AND "NZZZZZZZZZZZZ"

or

= "M" AND < "O"

John W. Vinson[MVP]