Originally posted by TimberWolf
View Post
Taking your idea, after populating 3 rows, I can do a quick 'yes/no' lookup. For example, let's say that I have
54141
54213
54222
I ask the question 'are there are columns which begin 555?' and go no further if the answer is no
And 'are there any columns which begin 444?' and go no further if the answer is no
And 'are there any columns which begin 122?' and go no further if the answer is no
Similarly for the final two columns
Not anything like as selective as your 'complete' solution, but perhaps a useful short cut. And much easier to code!
EDIT: Bah humbug, only fractionally quicker than before, as suspected (i.e. it should execute in 117/125ths of the time)
Comment