1) How are you opening to get that information?

I.e cant you just use
VB Code:
  1. strSQLQuery = "SELECT questionnumber FROM tablename"

Shouldnt that return all options anyway?
If you want a count you did it in the one u posted b4!

2) Check out UNION should help you!!

example:
VB Code:
  1. Select name from table1 where name="rj" 

  2. UNION 

  3. select whatname from table2 where whatname="rj"