change string in a cell and connect to database

[newapa]

Hi!


i need a macro that change a table in a selection and connect to database and check how many rows it get with that selection.


somthing like this.

    select                                                   employd1     eployd2       employd3


    select name from table where name = Mike                 250 row       300 row      0 row
    select lastname from table where lastname = arthur       30 row        580 row      52 row
    select street from table where street = street123        0  row        0 row        5 row

as u can se i'm trying to change table name so it get the column name insted like emplyod1,2 or 3 and connect to database and write how many rows it get from that selection.
insted of creat 3 selection and only table name needed to change.


Any help will be highly appreciated


thx in advance