Here is a sample of my data, note price 6-10 will be left at 0. I don't really know what you mean by a sample query output...
<CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=50% ><TR ><TD CLASS="AccTBMain" border-left=1px solid colSpan= 23 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInner" align=Left ><font color="White">ARI_Info : Table</font></TD><TD CLASS="AccTBInner" align=right >Access 2003</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccHDRMain" align=left >Part Qualifier</TD><TD CLASS="AccHDRMain" align=left >Part Number</TD><TD CLASS="AccHDRMain" align=left >Description</TD><TD CLASS="AccHDRMain" align=left >List Price</TD><TD CLASS="AccHDRMain" align=left >Stock</TD><TD CLASS="AccHDRMain" align=left >Supercession or Alternative Part Number</TD><TD CLASS="AccHDRMain" align=left >Part Weight</TD><TD CLASS="AccHDRMain" align=left >Price 1</TD><TD CLASS="AccHDRMain" align=left >Price 2</TD><TD CLASS="AccHDRMain" align=left >Price 3</TD><TD CLASS="AccHDRMain" align=left >Price 4</TD><TD CLASS="AccHDRMain" align=left >Price 5</TD><TD CLASS="AccHDRMain" align=left >Price 6</TD><TD CLASS="AccHDRMain" align=left >Price 7</TD><TD CLASS="AccHDRMain" align=left >Price 8</TD><TD CLASS="AccHDRMain" align=left >Price 9</TD><TD CLASS="AccHDRMain" align=left >Price 10</TD><TD CLASS="AccHDRMain" align=left >Box Height</TD><TD CLASS="AccHDRMain" align=left >Box Width</TD><TD CLASS="AccHDRMain" align=left >Box Length</TD><TD CLASS="AccHDRMain" align=left >Handling Type</TD><TD CLASS="AccHDRMain" align=left >Handling Value</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >ZAM</TD><TD CLASS="AccDataElem" >0004001</TD><TD CLASS="AccDataElem" >STRAINER</TD><TD CLASS="AccDataElem" >0.37</TD><TD CLASS="AccDataElem" >10</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0.22</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >KL</TD><TD CLASS="AccDataElem" >001233</TD><TD CLASS="AccDataElem" >N L A</TD><TD CLASS="AccDataElem" >2.75</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >HOF</TD><TD CLASS="AccDataElem" >010557S</TD><TD CLASS="AccDataElem" >BLADE CUTTER 6IN EART</TD><TD CLASS="AccDataElem" >9.83</TD><TD CLASS="AccDataElem" >5</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >7.29</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >SIL</TD><TD CLASS="AccDataElem" >02-050-0</TD><TD CLASS="AccDataElem" >HANDLE BOLT, SNAPPER</TD><TD CLASS="AccDataElem" >1.14</TD><TD CLASS="AccDataElem" >20</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0.56</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >ROT</TD><TD CLASS="AccDataElem" >207</TD><TD CLASS="AccDataElem" >CONNECTOR SPADE 22 18</TD><TD CLASS="AccDataElem" >0.4</TD><TD CLASS="AccDataElem" >10</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0.16</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD><TD CLASS="AccDataElem" >0</TD></TR><TR ><TD ID="IE" CLASS="AccIEOnlyMain" colSpan= 23 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccIEOnlyInnerRight" > Record: </TD><TD CLASS="AccButton" >
</TD><TD CLASS="AccIEOnlyData" > 1 </TD><TD CLASS="AccButton" >
</TD><TD CLASS="AccIEOnlyInnerLeft" > of 5</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccIEOnlyMain" colSpan= 23 ><TABLE cellSpacing=0 cellPadding=0 width="100%" align=left VALIGN="TOP" ><TR ><TD ID="Data291835964" CLASS="AccInfoBarInnerRight" >ARI_Info</TD><TD ID="Info291835964" CLASS="AccInfoBarData" > Record Count: 5</TD></TR></TABLE></TD></TR><TR ><TD CLASS="tpkrow" colSpan = 23 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER>