Help with Bill Of Lading

[Jim]

Hello,
I have a subreport that lists different products, their dimensions & weight
for a bill of lading. For example:

1 @ 10x10x12 #150
1 @ 12x12x12 #30

If there are more then one of the same dimension, then it lists the products
together and totals the combined weight for that item.
So the below example

Product 1 10x10x12 #75
Product 2 10x10x12 #25
Product 3 12x12x10 #50 would come out as:

2 @ 10x10x12 #100
1 @ 12x12x12 #50

The problem is that now we have items with different shipping classes and
they have to be listed seperately in a another part of the report along with
their collective weight. What I am getting now is:

1 #30 Class 55
1 #50 Class 55
1 #25 Class 85

What I need is:

2 #80 Class 55
1 #25 Class 85

Does anyone have any ideas?
Thanks

Jim

 

[Allen Browne]

1. Create a query into this table.

2. In query design view, depress the Total icon on the toolbar (upper sigma
icon.) Access adds a Total row to the query design grid.

3. Drag the fields that should be grouped together into the grid. In your
first example, that appears to be the 10x10x12 field. In your second
example, it appears to be the Class field. In the Total row under this
fields, Access will set Group By.

4. Drag the weight field into the grid. In the Total row under this field,
choose Sum, so it adds the weights.

5. If each row represents just one product, drag the Product field into the
grid, and choose Count in the Total row.

Once the query is giving you the right results, you can use it as the
RecordSource for your report.

 

[Jim]

Thanks I will try it.

Jim

1. Create a query into this table.

2. In query design view, depress the Total icon on the toolbar (upper
sigma icon.) Access adds a Total row to the query design grid.

3. Drag the fields that should be grouped together into the grid. In your
first example, that appears to be the 10x10x12 field. In your second
example, it appears to be the Class field. In the Total row under this
fields, Access will set Group By.

4. Drag the weight field into the grid. In the Total row under this field,
choose Sum, so it adds the weights.

5. If each row represents just one product, drag the Product field into
the grid, and choose Count in the Total row.

Once the query is giving you the right results, you can use it as the
RecordSource for your report.