Problem with Count/filter?

  • Thread starter Thread starter Twisty
  • Start date Start date
T

Twisty

I have tried to show what my problem is in a "report" under here.

PROJECT ID-NO PLANNED ACTUALLY
DELIVERY-DATE DELIVERED


10 234 1. juni 2009 20. juni 2009
10 235 1. juni 2009 20. juni 2009
11 345 4. juni 2009 25. juni 2009
11 346 4. juni 2009 25. juni 2009
11 347 4. juni 2009 25. juni 2009
12 456 15. juni 2009
12 457 15. juni 2009 _______________________________________________________
SUM 3 5

One project can have one or more id-numbers, which means the table has many
equal project - numbers, but the Id - number is uniqe. (Never the same in any
prosjects). As you can see I have managed to count number of projects, 3,
thats correct. but 5 is wrong,, because it is only two projects which is
delivered.

In this report I only need one line pr project number, like this:

PROJECT ID-NO PLANNED ACTUALLY
DELIVERY-DATE DELIVERED


10 234 1. juni 2009 20. juni 2009
11 345 4. juni 2009 25. juni 2009
12 456 15. juni 2009
_______________________________________________________
SUM 3 2


Is this possible to do?
 
In report design view, choose the Project field in the Sorting And Grouping
dialog. Make it a Grouping, with a Group Footer. This adds a new Project
Group Footer section to your report.

Add a text box to this new section, and set these properties:
Control Source =IIf(Count([Actually Delivered]) > 0, 1, 0)
Running Sum Over All
Format General Number
 
Back
Top