G
Guest
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
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