Friends,
I'm trying to help out a co-worker with his query. The person that set up the MS Access database put a ":" at the end of the column name.
"Branch Number:" so when he does his select:
rs.Open "Select * from Data where [Branch Number:] =" & Ca, cn
it doesn't work. I told him I think there is a way to select by column number but I can seem to find any examples. Can someone point me to some examples please?
Thanks in advance
Rick