Thanks for the article, it is very useful.

I would love to see your > solution and can I ask for a between solution also.

This is the query that I'm trying to do at the moment:

I need a query that does both And's or Ors and works on multiple tables. Eg the query is about house features The Square foot is stored in one table The rooms are stored in another table The features are stored in another table again (Similar to your scenario in your article).

The user wants to query a house that is between 2000 and 3000 square foot, with 3 bathrooms (from the rooms table) and with the following features eg porch, fireplace (each stored as a record in the features table)

That was the simplified version, I would love to be able to expand it to query other things that we store about the houses.

Jodie