I want to:
sql = Select PhoneNum from table
open rs
If not rs.BOF then
Do While NOT rsEOF
Count = Count + 1
PhoneNum(count) = rs("PhoneNum"
rs.movenext
Loop
end if
and end with some variables:
PhoneNum1 = 590-1234
PhoneNum2 = 590-1235
PhoneNum3 = 590-1236
BUT
Count = Count + 1
PhoneNum(count) doesn't work!
Does anyone know how to increment a veriable?
Thanks!
Lyle
sql = Select PhoneNum from table
open rs
If not rs.BOF then
Do While NOT rsEOF
Count = Count + 1
PhoneNum(count) = rs("PhoneNum"
rs.movenext
Loop
end if
and end with some variables:
PhoneNum1 = 590-1234
PhoneNum2 = 590-1235
PhoneNum3 = 590-1236
BUT
Count = Count + 1
PhoneNum(count) doesn't work!
Does anyone know how to increment a veriable?
Thanks!
Lyle