retrieving table headers?

hi.. i need to retrieve e headers from my table.... and some data.. but don't really know how to explain.. but let me show u e table layout..




aaa |&nbsp Bbb |&nbsp ccc |&nbsp ddd |&nbsp eee |&nbsp fff |&nbsp ggg|
a1&nbsp| b2&nbsp| c2 &nbsp | d2 &nbsp | e2 &nbsp| f2 &nbsp| g2 &nbsp|


but when i wanna retrieve it this way


aaa &nbsp a1
bbb &nbsp b2
ccc &nbsp c2

and so on... and i also need to add in new headers everytime.. so it has to be auto retrieving nt hardcoded.. by e way , i'm using ms access.. thanks

Check this out:

<!-------------------------------------------------------------------------------------------------
Table header row
-------------------------------------------------------------------------------------------------->
<%
If NOT rs.EOF Then
rs.MoveFirst
%>
<table width="95%" bgcolor="DEDFDE" border="1" >
<tr>
<%
For Each Fld In rs.Fields
%>
<td><%= Fld.Name %></td>
<%
Next
%>
</tr>

<!-------------------------------------------------------------------------------------------------
Now comes the data
-------------------------------------------------------------------------------------------------->
<%
Do While NOT rs.EOF
%>
<tr>
<%
For I = 0 To rs.Fields.Count - 1
%>
<td><%= rs.Fields(i).value %></td>
<%
Next
%>
</tr>
<%
rs.MoveNext
Loop
%>
end if

hi./.... wad if i need to add in new headerS? how do i do usingSQL statmentS? like INSERT or wad? thanks in advance

what if you wrote in proper English?