You see we have an access report called Invoiced Shipments Report.  It is
created where in you can put the date range for all or each customers.  If
you want only certain customers you have to type in the customers you only
want and if you want all customers you just have to click the check box.  

Example:  from the form the dates I wanted are from 08/30/04 to 08/28/05
(NOTE:  this is our fiscal year for the year 2004).  For customers I selected
the check box because I want all customers.  When the report comes out the
fields are:

Customer    Order No    Date           Shipper No  Item No  Qty    Amount
ABRA       
    7725
        11/19/2004  07-33238    510546    7104    $1,136.00
        01/25/2005  07-34011    510546    8104    $1,215.00
                    ____    ________
                    15,208    $2,351.00

PLEASE NOTE THAT THESE ARE THE TOTAL QTY AND TOTAL AMOUNT FOR THE YEAR 2004
FOR THIS ITEM NO FOR THIS CUSTOMER AND FOR THIS ORDER NO.

I WILL PRINT THIS REPORT... THEN ...

I will go back to the form of same access report and this time I will only
change the date range, in this case the date range are from 8/29/05 to /27/06
(NOTE:  this is our fiscal year for the year 2005).  When the report comes
out the fields are:

Customer No. Order No  Date    Shipper No    Item No   Qty   Amount
ABRA       
        8614
        07/20/2005  07-14545    510546     4200  $3,822.00
        04/17/2006  07-15404    510546     1655  $1,506.00
                     ____   ________
                     5,855  $5,328.00

PLEASE NOTE THAT THESE ARE THE TOTAL QTY AND TOTAL AMOUNT FOR THE YEAR 2005
FOR THIS ITEM NO FOR THIS CUSTOMER AND FOR THIS ORDER NO.

I WILL PRINT THIS REPORT AGAIN ...

Now, having the example above, what I need to accomplish in this access
report is, please see below:

CUST NO    CUST NAME  ORDER NO   ITEM NO  ‘04 QTY  '04 AMT    ‘05 QTY '05AMT
ABRA    ABRAHM     7725       510546       5,208  $2,351.00      
                                 8614       510546                             
    5.855  $5,328.00

PLEASE TAKE NOTE THAT I DO NOT WANT THE REPORTS TO BE CHANGED,  I JUST NEED
TO ADD THE TOTAL OF YEAR’S QTY AND EACH YEAR’S  AMOUNT AT THE FOOTER PER ITEM
IN ONE REPORT BUT AS YOU CAN SEE THE YEAR 2004 AND YEAR 2005 HAS TO BE MERGED
AT THE FOOTER SO I CAN COMPARE PER ITEM PER YEAR.

PLEASE HELP HOW TO ACCOMPLISH THIS SCENARIO... THANK YOU... REJ