Count unique PO's and invoice numbers in query?

A

allie357

have to count the PO's (purchase orders) and invoice numbers for about
500 companies. Each company has several po's and invoice numbers
associated with it. Duplicate entries of the pos and invoice numbers
exist in my table due to the way line items are counted on a PO. I
have to count all of the unique PO's. Then, I have to count all of the
unique invoice numbers. However, if the invoice number has debits and
credits I have to go through and match the debits and the credits. If
the total amount is zero, the invoice number cannot be included in the
original count.
Can someone help me build this query?

This is what I have so far:
Code:
--------------------------------------------------------------------------------

SELECT [2008 tblCommInfo].[Vendor Name], [2008 tblCommInfo].
[Accounting Date], [2008 tblCommInfo].Category, [2008 tblCommInfo].
[Invoice Num], [2008 tblCommInfo].[PO Number], [2008
tblCommInfo].AmountFROM [2008 tblCommInfo]WHERE ((([2008 tblCommInfo].
[Vendor Name]) Like "Mcgraw-Hill*") AND (([2008 tblCommInfo].Category)
="PO"))ORDER BY [2008 tblCommInfo].[Accounting Date], [2008
tblCommInfo].[Invoice Num];

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/
html;charset=windows-1252">
<TITLE>K_Analysis_ARK_12308_PO</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Calibri"
COLOR=#000000><CAPTION><B>K_Analysis_ARK_12308_PO</B></CAPTION></FONT>

<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Vendor Name</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Accounting Date</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Category</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Invoice Num</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>PO Number</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Amount</FONT></TH>

</TR>
</THEAD>
<TBODY>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$900.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$900.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,050.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4204374</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>752373</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$319.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30363</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$100.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30363</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770251</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,840.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30364</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770464</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$2,220.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30364</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30395</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770256</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,480.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30395</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30399</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770242</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,480.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30399</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30503</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770465</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$2,220.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30503</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251043</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$16.17</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251043</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771678</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$260.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251044</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771771</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$79.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251044</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251614</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771761</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$105.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251614</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$14.55</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/5/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30626</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771823</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$160.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/5/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30626</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30627</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772081</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$480.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252861</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252861</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772348</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$255.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252864</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252864</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772023</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$230.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252865</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772172</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$299.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252865</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254914</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772511</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$123.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254914</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254924</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771557</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$345.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254924</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254932</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254932</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772107</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,082.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254936</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254936</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772593</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$250.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30554</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30554</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>768764</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,200.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30566</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770753</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,440.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30566</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30566</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770753</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$160.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30567</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770749</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$4,800.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30568</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770752</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$800.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30568</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30569</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770750</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$4,000.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30569</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252858</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252858</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772293</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$123.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4253353</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>741950</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$349.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4253353</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>741950</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>($349.00)</FONT></TD>

</TR>
</TBODY>
<TFOOT></TFOOT>
</TABLE>
</BODY>
</HTML>
 
J

Jeff Boyce

"How" depends on "what" ... please describe your underlying data structure
to get more ideas about how you could do this query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

allie357 said:
have to count the PO's (purchase orders) and invoice numbers for about
500 companies. Each company has several po's and invoice numbers
associated with it. Duplicate entries of the pos and invoice numbers
exist in my table due to the way line items are counted on a PO. I
have to count all of the unique PO's. Then, I have to count all of the
unique invoice numbers. However, if the invoice number has debits and
credits I have to go through and match the debits and the credits. If
the total amount is zero, the invoice number cannot be included in the
original count.
Can someone help me build this query?

This is what I have so far:
Code:
--------------------------------------------------------------------------------

SELECT [2008 tblCommInfo].[Vendor Name], [2008 tblCommInfo].
[Accounting Date], [2008 tblCommInfo].Category, [2008 tblCommInfo].
[Invoice Num], [2008 tblCommInfo].[PO Number], [2008
tblCommInfo].AmountFROM [2008 tblCommInfo]WHERE ((([2008 tblCommInfo].
[Vendor Name]) Like "Mcgraw-Hill*") AND (([2008 tblCommInfo].Category)
="PO"))ORDER BY [2008 tblCommInfo].[Accounting Date], [2008
tblCommInfo].[Invoice Num];

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/
html;charset=windows-1252">
<TITLE>K_Analysis_ARK_12308_PO</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Calibri"
COLOR=#000000><CAPTION><B>K_Analysis_ARK_12308_PO</B></CAPTION></FONT>

<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Vendor Name</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Accounting Date</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Category</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Invoice Num</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>PO Number</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Amount</FONT></TH>

</TR>
</THEAD>
<TBODY>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$900.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$900.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,050.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4204374</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>752373</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$319.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30363</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$100.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30363</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770251</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,840.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30364</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770464</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$2,220.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30364</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30395</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770256</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,480.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30395</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30399</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770242</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,480.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30399</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30503</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770465</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$2,220.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30503</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251043</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$16.17</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251043</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771678</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$260.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251044</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771771</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$79.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251044</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251614</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771761</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$105.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/3/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4251614</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$14.55</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/5/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30626</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771823</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$160.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/5/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30626</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30627</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772081</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$480.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252861</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252861</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772348</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$255.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252864</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252864</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772023</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$230.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252865</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772172</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$299.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252865</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254914</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772511</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$123.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254914</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254924</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>771557</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$345.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254924</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254932</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254932</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772107</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,082.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254936</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/6/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4254936</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772593</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$250.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30554</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30554</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>768764</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,200.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30566</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770753</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,440.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30566</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30566</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770753</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$160.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30567</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770749</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$4,800.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30568</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770752</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$800.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30568</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30569</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770750</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$4,000.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30569</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$60.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252858</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$25.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4252858</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>772293</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$123.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4253353</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>741950</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$349.00</FONT></TD>

</TR>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/9/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4253353</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>741950</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>($349.00)</FONT></TD>

</TR>
</TBODY>
<TFOOT></TFOOT>
</TABLE>
</BODY>
</HTML>
Click to expand...
 
A

allie357

"How" depends on "what" ... please describe your underlying data structure
to get more ideas about how you could do this query.

Regards

Jeff Boyce
Microsoft Office/Access MVP




have to count the PO's (purchase orders) and invoice numbers for about
500 companies. Each company has several po's and invoice numbers
associated with it. Duplicate entries of the pos and invoice numbers
exist in my table due to the way line items are counted on a PO. I
have to count all of the unique PO's. Then, I have to count all of the
unique invoice numbers. However, if the invoice number has debits and
credits I have to go through and match the debits and the credits. If
the total amount is zero, the invoice number cannot be included in the
original count.
Can someone help me build this query?
Click to expand...
This is what I have so far:
Code:
---------------------------------------------------------------------------­-----
Click to expand...
SELECT [2008 tblCommInfo].[Vendor Name], [2008 tblCommInfo].
[Accounting Date], [2008 tblCommInfo].Category, [2008 tblCommInfo].
[Invoice Num], [2008 tblCommInfo].[PO Number], [2008
tblCommInfo].AmountFROM [2008 tblCommInfo]WHERE ((([2008 tblCommInfo].
[Vendor Name]) Like "Mcgraw-Hill*") AND (([2008 tblCommInfo].Category)
="PO"))ORDER BY [2008 tblCommInfo].[Accounting Date], [2008
tblCommInfo].[Invoice Num];
Click to expand...
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/
html;charset=windows-1252">
<TITLE>K_Analysis_ARK_12308_PO</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Calibri"
COLOR=#000000><CAPTION><B>K_Analysis_ARK_12308_PO</B></CAPTION></FONT>
Click to expand...
<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Vendor Name</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Accounting Date</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Category</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Invoice Num</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>PO Number</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>Amount</FONT></TH>
Click to expand...
</TR>
</THEAD>
<TBODY>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$900.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$900.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>28444</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>759501</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$1,050.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/1/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>4204374</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>752373</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$319.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30363</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$100.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30363</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770251</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,840.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30364</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770464</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$2,220.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30364</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$40.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30395</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>770256</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>$3,480.00</FONT></TD>

<TR VALIGN=TOP>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>MILLIPORE CORP</FONT></TD>
<TD BORDERCOLOR=#d0d7e5  ALIGN=RIGHT><FONT style=FONT-SIZE:11pt
FACE="Calibri" COLOR=#000000>7/2/2007</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>PO</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000>30395</FONT></TD>
<TD BORDERCOLOR=#d0d7e5 ><FONT style=FONT-SIZE:11pt FACE="Calibri"
COLOR=#000000><BR></FONT></TD>
<TD
Click to expand...

...

read more »- Hide quoted text -

- Show quoted text -
Click to expand...

I am trying to pull all of this data from one table in the database.
Vendor Name, Accounting Date, Category, Invoice Number, PO Number, and
Amount.
Each purchase order can have multiple line items so each one can have
many invoice numbers associated with it. Which means there are
duplicate invoice numbers listed in a simple query. The PO numbers
can be listed multiple times as well.
 
J

Jeff Boyce

Are you saying that each record will have the same [VendorName] and
[AccountingDate] if the [PONumber] is the same (i.e., "one [purchase order]
can have ... many invoice numbers)?

If so, you are working with a spreadsheet, not a well-normalized relational
database.

In a well-normalized relational database, you'd use a minimum of two tables
to hold that data. The first table would have information about the
purchase order only. The second table would be a "child" table, with a
field to hold the [PONumber] and the details of each (related)
[InvoiceNumber].

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP



"How" depends on "what" ... please describe your underlying data structure
to get more ideas about how you could do this query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

I am trying to pull all of this data from one table in the database.
Vendor Name, Accounting Date, Category, Invoice Number, PO Number, and
Amount.
Each purchase order can have multiple line items so each one can have
many invoice numbers associated with it. Which means there are
duplicate invoice numbers listed in a simple query. The PO numbers
can be listed multiple times as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate list based on multiple criteria 1
trying to build a string with stringbuilder fails 3
find string in web page 3
pages don't work in Firefox? 2
font embedding 1
Second Question for Kevin Spencer 5
Question for Kevin Spenser (continued) 5
Exception when accessing mdf file when using IIS and aspnet_wp.exe 4

Top