subtotals

[LRosiles]

Not sure if the question belongs in queries or reports. I've a list of product codes that we produce daily, weekly, monthly. Some repeat several times within a week or month. I want to list them in order by cost. I can do that, but when they repeat, I wanted to combine them into one subtotal, then get sorted by cost with the other product codes.

Right now, I'm dumping the table into Excel and doing it manually. I sometimes have 7 lines of the same product code. I insert a line and subtotal them by their product code. Then, I delete the data leaving the subtotal line. I then can sort them with the other subtotal and other once product codes.

:-[ I'm hoping this is an easy answer. I'm not good with Access. It's turned out to more of a trial and error thing for me.

Thanks

Laura

 

[jdraw]

Not sure if the question belongs in queries or reports. I've a list of product codes that we produce daily, weekly, monthly. Some repeat several times within a week or month. I want to list them in order by cost. I can do that, but when they repeat, I wanted to combine them into one subtotal, then get sorted by cost with the other product codes.

Right now, I'm dumping the table into Excel and doing it manually. I sometimes have 7 lines of the same product code. I insert a line and subtotal them by their product code. Then, I delete the data leaving the subtotal line. I then can sort them with the other subtotal and other once product codes.

:-[ I'm hoping this is an easy answer. I'm not good with Access. It's turned out to more of a trial and error thing for me.

Thanks

Laura

What are the fields in your Table?
What exactly is the report you're trying to create?

You mention product codes, daily, weekly and monthly production, but the you want a report by cost?

 

[LRosiles]

Table looks like this. I'm looking to combine (sum) the quantities by SKU #
In example below, there are six entries for 899027. I want one line to represent the total of the group on a report.



MO_NUMBER SKU PROD_DATE ORD_QTY FIRST_QUALITY SECOND_QUALITY NO_SHOW
9947686 899981 2/13/2008 295 281 9 5
9945547 899978 9/12/2007 339 333 11 0
9944837 899974 7/24/2007 150 180 13 0
9934040 899055 5/11/2005 810 810 0 0
9947401 899027 1/17/2008 1114 1132 0 0
9947273 899027 1/7/2008 800 788 0 12
9946953 899027 12/7/2007 600 590 0 10
9946521 899027 11/9/2007 1200 1198 0 2
9946871 899027 12/3/2007 600 592 0 8
9947028 899027 12/13/2007 800 796 0 4
9946520 899026 11/9/2007 1200 1198 0 2