I'm currently making a database on Cottages for School, and I have to make it easy to use, therefore I'm working with Forms.
In one of my forms, I have a button which says search, and when pressed, a pop up box appears asking various questions (Destination, Price etc), this is linked to a query I have made.
Anyway, I've got a bit of a problem really, because to get information on the Cottages, you have to match every single field.
For example, If I have a Cottage in Devon, which costs 150-200 per week and occupies 5 people, I would have to enter Devon, 150-200 then 5 in the pop-up boxes. However, I want to be able to enter just Devon, or just the price sometimes, is there anyway of doing this?
I hope I've made myself clear, sorry if I havn't, but any help would be greatly appreciated!