Access Query all records execpt

[Guest]

I need to generate a report which only includes certain records from a field,
for example, the columnn is called fruit, I only want entries which contain
apple

 

[Al Campagna]

Iamwhoiam,
Use a query (not a table) as the RecordSource for the report, and in that query use
= "Apple"
as the criteria against the Fruit field.