Thanks again for everyones help.
Ok here's my dilema and I think I just need to be brought in the right direction on how I can accomplish this:
I have a "rejection" report currently that is grouped on a unique 5 digit location code and then is grouped by week. In my report for each week that is in the user specified date range, I have a sum of the # of units from each record in that week and also the sum of the amount ($) from each record in that week. Looks somewhat like this:
WeekEnding..........Units..........Amount
1/7/2006..............30.............$451.80
1/14/2006............294............$4427.64
1/21/2006............34..............$512.04
etc
etc
Everything is working perfectly now with that because of this great site and all the help I received. What I want to do now is be able to show what has been reworked for those weeks and also show the difference between the 2 on the report. Similar to below:
WeekEnding......Units.....Amount.......ReworkUnits....ReworkAmount......UnitDifference.....AmountDifference
1/7/2006...........30........$451.80......28...............$400.00...............2.....................$51.80
1/14/2006.........294.......$4427.64....284..............$4027.64.............10....................$400.00
1/21/2006.........34.........$512.04.....34................$512.04...............0.....................$0.00
etc
etc
I have created a form that the user can enter the week ending date, units, amount and this is populating a new table.
I'm just having trouble coming up with a way that I can create a report similar to the one above that shows all this data.
Thanks for everyones help.
Ok here's my dilema and I think I just need to be brought in the right direction on how I can accomplish this:
I have a "rejection" report currently that is grouped on a unique 5 digit location code and then is grouped by week. In my report for each week that is in the user specified date range, I have a sum of the # of units from each record in that week and also the sum of the amount ($) from each record in that week. Looks somewhat like this:
WeekEnding..........Units..........Amount
1/7/2006..............30.............$451.80
1/14/2006............294............$4427.64
1/21/2006............34..............$512.04
etc
etc
Everything is working perfectly now with that because of this great site and all the help I received. What I want to do now is be able to show what has been reworked for those weeks and also show the difference between the 2 on the report. Similar to below:
WeekEnding......Units.....Amount.......ReworkUnits....ReworkAmount......UnitDifference.....AmountDifference
1/7/2006...........30........$451.80......28...............$400.00...............2.....................$51.80
1/14/2006.........294.......$4427.64....284..............$4027.64.............10....................$400.00
1/21/2006.........34.........$512.04.....34................$512.04...............0.....................$0.00
etc
etc
I have created a form that the user can enter the week ending date, units, amount and this is populating a new table.
I'm just having trouble coming up with a way that I can create a report similar to the one above that shows all this data.
Thanks for everyones help.