asp classic - Multiple fields to display from Access DB to simple table in asp page -

i need have series of tables on page each have list of categories. each category has salary , number of respondents. said , done, should on page: https://i.stack.imgur.com/rk5xa.jpg

my database looks this: https://i.stack.imgur.com/bqoz3.jpg

i tried this:

<% until myresults.eof %>            <tr>              <td><% response.write myresults.fields.item("categories").value %></td>              <td><% response.write myresults.fields.item("salary").value %></td>              <td><% response.write myresults.fields.item("respondents").value %></td>            </tr>            <% myresults.movenext            loop %> 

...but shows all of information in database. example need ones under "bybusinesssector" show in table. (and yes, in classic asp. can't other version @ time due company wanting format.)

i don't know if built database wrong including information doesn't need show.

maybe should write database differently? or if made reference id numbers instead? i'm not sure.