This is the table I got from your data, but
I don't understand what exactly you are after
You mention some colour coding is this for
the AD_1, AD_2 etc....<HTML><HEAD><STYLE TYPE="text/css"></STYLE><TITLE></TITLE></HEAD><BODY bgcolor="#9F9F9F" ><FONT FACE="arial, helvetica, sans-serif"><LEFT><TABLE bgcolor="#FFFFFF" Border=2><TR><TD Align=Right bgcolor="#DFDED0">
</TD><TD Align=Center bgcolor="#DFDED0">
A</TD><TD Align=Center bgcolor="#DFDED0">
B</TD><TD Align=Center bgcolor="#DFDED0">
C</TD><TD Align=Center bgcolor="#DFDED0">
D</TD><TD Align=Center bgcolor="#DFDED0">
E</TD><TD Align=Center bgcolor="#DFDED0">
F</TD><TD Align=Center bgcolor="#DFDED0">
G</TD><TD Align=Center bgcolor="#DFDED0">
H</TD><TD Align=Center bgcolor="#DFDED0">
I</TD><TD Align=Center bgcolor="#DFDED0">
J</TD><TD Align=Center bgcolor="#DFDED0">
K</TD><TD Align=Center bgcolor="#DFDED0">
L</TD><TD Align=Center bgcolor="#DFDED0">
M</TD><TD Align=Center bgcolor="#DFDED0">
N</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">
1</TD><TD Align=Center >AGENT</TD><TD Align=Center >MLS</TD><TD Align=Center >STATUS</TD><TD Align=Center >PRICE</TD><TD Align=Center >TYPE</TD><TD Align=Center >AD_1</TD><TD Align=Center >PRICE_1</TD><TD Align=Center >DATE ADVERTISED</TD><TD Align=Center >AD_2</TD><TD Align=Center >PRICE 2</TD><TD Align=Center >DATE ADVERTISED</TD><TD Align=Center >AD_3</TD><TD Align=Center >PRICE 3</TD><TD Align=Center >DATE ADVERTISED</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">
2</TD><TD Align=Center >CINDY</TD><TD Align=Center >8123</TD><TD Align=Center >Active</TD><TD Align=Center >169000</TD><TD Align=Center >L</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">
3</TD><TD Align=Center >KEN</TD><TD Align=Center >9156</TD><TD Align=Center >Active</TD><TD Align=Center >33000</TD><TD Align=Center >R</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">
4</TD><TD Align=Center >DALSE</TD><TD Align=Center >7864</TD><TD Align=Center >Active</TD><TD Align=Center >20900</TD><TD Align=Center >C</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD></TR></TABLE></LEFT></BODY><P</HTML>
_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font></font></font>
<font color="green">[url]http://www.gwds.co.nz/ - Under Construction[/url]
This message was edited by Ivan F Moala on 2002-04-15 02:15