Big Query Assistance Required
Posted on 2007-11-21
I know I have another opened question which has to do with this but I have a problem putting it all together.
This is want I'm trying to do:
I have 4 ComboBoxes
3. MAX PRICE
By default I'm set the comboBox Text String to ANY
My biggest problem here is going to be getting a queries for all combinations.
The way I started doing it is by using an IF Statement
If ComboBox1.text = 'ANY' then
If ComboBox1.text<>'ANY' then
And this goes for all the others.
Is this the best way to do this?
Also, with the last ComboBox (PostCode) I want to search the First 3 Digits of the postcode and not the full 6 Digits
I guess this is complex, but if you guys cannot help NO-ONE can....So I'm giving MAX Points possible for it.