Search results

Sorry it was replied in error. I can't really because it's work related but as an example there are 231 different options for just products or services

Hey Isaac, Thanks for the amazing reply! And totally see your points there. When I said it was rubbish I meant that the structure is totally wrong and really I was being lazy and hoping that someone might know some magic code to make the database do what I wanted it to do...and that person...

Yeah I gathered that but wondered if there was a way around it rather than making separate tables. I know its not ideal but it wouldn't be for everyday use. If I was to do it correctly then I would require a lot of tables as some of the columns contain over 30 different options which isn't an...

Hi Mike, I have uploaded a sample of the database just so you can get the idea. If you search if the AND logic on its own it works fine (the 1st 3 options) and if you search the OR logic (the last one) it also works fine. but when you search together it fails. What I think I want to happen is...

I think the answer to this will be no....go build a better database but thought I would ask. I have a database set up with different columns, the majority of them contain a yes/no reply but there are also columns that has data about the same subject but across a few fields, for example...