I need to display data from two separate fields in a .mdb file, and I can't envision how this is done. I'd like it to display the data like this:
https://i.stack.imgur.com/rk5Xa.jpg
I set my access database like this:
https://s16.postimg.org/o8nmjucph/411_a.jpg
I've already created a page for this and plugged in some of the info, but I can't figure out how to display multiple fields.
I thought this would work:
Code:
<% do 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 this shows all of the information in the database. For this example I just need the ones under "byBusinessSector" to show in this table.
I think I may have built the database wrong. Can .asp pages only read one data cell at a time? I'm not sure. Help!