Advance Report Help

[OldCityCat]

The report is based on a detail type table, has a single group on the shipment number which is a text field.
The records have a many to one relationship within themselves, many shipment number to one bill.
So one bill may have 15 widgets or 1, I think you know what I’m getting at.
The report is summarizing all shipment number to one invoice, which I suspect is not uncommon.
I need is a way to count these sub-total’s
Widgets Bills
22 1
17 2
12 5
8 9

So 22 bill only have one widget, 17 bills have 2, 12 bills have 5 and so on.


Obviously there’s one column in the report for widget count which is a calculated field,
I thought about just sorting on the widget field but it’s a calculated field so it not available in the sort by option.
Or maybe a query that would return the count.
I just can’t seem to work out the logic.

Thank in advance for any and all suggestions
OldCityCat

[NTC]

the answer depends on what your ultimate layout is - - but in general I think you want to use the group feature in reports - group on widget type. Option to have a group footer (maybe a header too...) - and then in the footer count a field that is in the detail section.

to design databases you need a textbook, in the version you have; easily available at Amazon or a big book store - and sample of this type design task will be there.

Hope this helps.