This one is odd. Total on a database shifts one cell left on the administrator login and the internal viewer but not for individual logins.
Looking at the HTML the last cell appears to be dropped but I don't know why the admin and individual would not have the same problem.
HTML below. Note one less row in second set. Let me know if you need something else.
Bob
[codebox] <TR onmouseover="this.className = 'rowselected';"
onmouseout="this.className = '{$row.shadeclassname}';" vAlign=top
{$row.shadeclass}>
<TD align=middle><A href="2007_Total_view.php?{$row.1editlink}">View</A>
 </TD>{if $allow_delete}
<TD align=middle><INPUT type=checkbox value="{$row.1recno}" name=mdelete[]>
<input type=hidden name="mdelete1[]" value="{$row.1id1}">Â </TD>{/if}
<TD>{$row.1YEARIN_value} </TD>
<TD>{$row.1MONTH_value} </TD>
<TD>{$row.1Stock_Number_value} </TD>
<TD>{$row.1Donor_First_Name_value} </TD>
<TD>{$row.1Donor_Middile_Initial_value}
</TD>
<TD>{$row.1Donor_Last_Name_value} </TD>
<TD>{$row.1Address_1_value} </TD>
<TD>{$row.1Address_2_value} </TD>
<TD>{$row.1City_value} </TD>
<TD>{$row.1State_value} </TD>
<TD>{$row.1Zip_Code_value} </TD>
<TD>{$row.1Phone_value} </TD>
<TD>{$row.1Email_value} </TD>
<TD>{$row.1Call_In_Date_value} </TD>
<TD>{$row.1Sale_Date_value} </TD>
<TD>{$row.1Lead_Source_value} </TD>
<TD>{$row.1Sub_Lead_Source_value} </TD>
<TD>{$row.1Year_value} </TD>
<TD>{$row.1Make_value} </TD>
<TD>{$row.1Model_value} </TD>
<TD>{$row.1VIN_value} </TD>
<TD>{$row.1Network_value} </TD>
<TD>{$row.1Gross_Sales_value} </TD>
<TD>{$row.1Total_Charges_value} </TD>
<TD>{$row.1Net_Recovery_value} </TD>
<TD>{$row.1ICA_FEES_value} </TD>
<TD>{$row.1V_DAC_FEES_value} </TD>
<TD>{$row.1NET_TO_CHARITY_value} </TD><!--{/foreach}--></TR>
<TR class=blackshade>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade></TD>
<TD class=blackshade>Total: {$showtotal_Gross_Sales} </TD>
<TD class=blackshade>Total: {$showtotal_Total_Charges} </TD>
<TD class=blackshade>Total: {$showtotal_Net_Recovery} </TD>
<TD class=blackshade>Total: {$showtotal_ICA_FEES} </TD>
<TD class=blackshade>Total: {$showtotal_V_DAC_FEES} </TD>
<TD class=blackshade>Total: {$showtotal_NET_TO_CHARITY} </TD></TR>[/codebox]
