Search results

Hi Bilbo Thanks for taking a look. I was able to get some assistance, and came up with this: =INDEX(A1:P1,MATCH(TRUE,A1:P1<>"",0)) (As it's an array, you need to use Ctrl+shift+Enter, for the formula to work) This worked a treat :) Thanks

Yes the number of columns is set. No it is not always the lowest number. It is which ever cell is populated first in the row. There can be other blank cells after the first populated cell. (Although very unlikely) THanks so much!

Hi I have an urgent problem, I hope many of you can help me solve. I need to display the result from a cell in a row, only where it is populated and where it is the first populated cell. i.e. Column A B C D E F G H Row1: , , , , , , 20, 23, 45 Result: 20 (as 20 is the first...

Thanks! although the requirements have changed. How about if I have a text box and I want another text box to display the values based on that text box value search criteria..... P.s where do you get sample access databases?

Hi I'm very new to Access and I need help on populating a text box based on a where clause from a combo box value. i.e. textbox.text = select field2 from table where field1 = field1.value (value from the combobox value) So in summary. When I change the value in the combo box, the text box...