I need help to create a query in Microsoft Access 2010 which allows me to change the vehicle depending on the number of passengers.

If the number of passengers is greater than 5 they need a mercedes Viano

AND

If the number of passengers is greater than 6 they need a Chrysler voyager.

Thank you.

There is probably a dozen ways of foing this...
Do you have a table that contains pairing values of vehicule, maximum passenger?

Yes I have attatched a print screen of my vehicle table

You should avoid using spaces in your field names. It will bite you soon or later.

So, the only time they need a Mercedes Viano is if there are six passengers?

that doesn't sound credible
surely your query shoudl return any vehicle which has the same or more number of seats
even for homework I can't see a situation where an (even a theoretical) organistaion is going to say.. sorry we cant hire a vehicle out to you because we have no 5 seat vehicles, despite their being 6 or 7 seater vehicles available