please help with summary

[joniraincloud]

Let's say I have 5 projects.

1. Type: Misc., Qty 650, binding: "none"

2. Type: Misc., Qty 500, binding: "none"

3. Type: Misc., Qty 10, binding: "none"

4. Type: Proposal, Qty 5, binding: "3-ring binder"

Type: Proposal, Qty 5, binding: "none"

5. Type: Report, Qty 4, binding: "Folder"

What I want seems like it ought to be really easy and in fact, I've done it before, but I can't figure it out.

I want a report that says:

Miscellaneous

binding: "none" -- Qty 1160

Total Misc projects -- 3

Proposals

binding: "3-ring binder" -- Qty 5

binding: "none" -- Qty 5

Total Proposal projects -- 1

Report

binding: "folder" -- Qty 4

Total Report projects -- 1

My report is calculating the total number of projects per type correctly (3 misc, 1 proposal, 1 report, etc) but not calculating the number of binders correctly.

I have a field called SummNumberofCopies which is a summary field totaling the NumberofCopies field. But it isn't working.

Instead, my report says

Miscellaneous

binding type: none, Qty 650

Total Misc Projects: 3

Proposals

binding type: 3-ring binder, Qty 10

Total Proposal Projects: 1

So you see, it's not adding the Qty field correctly.

It's doesn't work even if I eliminate the project type from the equation entirely and try to create a report that is just:

binder type | qty

In a "summary when sorted by binder type" part in my layout.

I get:

none | 650

3-ring binder | 10

none | 500

folder | 4

I know all that is probably confusing. I'm not very good at explaining things. I just don't understand why it worked on my other DB and not on this one.

p.s. BinderType and NumberofCopies are on the same table, ProjectType is on a different table. Does that make a difference? But that doesn't solve the problem with the second report. Argh!

[Brent Durland]

If you place your SummNumberofCopies field on a sub-summary part summarized by the binding field, you should get the total you're looking for. Have you tried that?

[joniraincloud]

For the just binding type report, I have a part:

sub-summary when sorted by BindingType

the fields in that part are: binding type & summNumberofCopies

I sort the report by BindingType and I get:

3-ring binder 10

None 10

Folder 8

I'm sure I'm just missing something obvious, but that's exactly what I have in my other DB and it works fine over there. NumberofCopies is a number field, SummNumberofCopies is a summary field. Some projects may have more than one binding type and a NumberofCopies should be associated with each binding type for each project.