Count headers with criteria

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi. In my report I've got a Header1 and Header2.

First come Header1 in where I've got most of the times two possibilities, A
or B.

Then I've got several Headers2 inside of each Header1.

I need to count all Headers2 inside of Header1. I mean, all number of
headers when Header1 is A and/or when it's B.

Please help me. :)

Regards,
Marco
 
Hi.

Doing that is counting all records in Details of Header2

This must be impossible.

Thanks,
Marco





golfinray said:
In the header, add a textbox and make the control source =count([header2])
--
Milton Purdy
ACCESS
State of Arkansas


Marco said:
Hi. In my report I've got a Header1 and Header2.

First come Header1 in where I've got most of the times two possibilities, A
or B.

Then I've got several Headers2 inside of each Header1.

I need to count all Headers2 inside of Header1. I mean, all number of
headers when Header1 is A and/or when it's B.

Please help me. :)

Regards,
Marco
Click to expand...
Click to expand...
 
Hi.

Doing that is counting all records in Details of Header2

This must be impossible.

Thanks,
Marco





golfinray said:
In the header, add a textbox and make the control source =count([header2])
--
Milton Purdy
ACCESS
State of Arkansas


Marco said:
Hi. In my report I've got a Header1 and Header2.

First come Header1 in where I've got most of the times two possibilities, A
or B.

Then I've got several Headers2 inside of each Header1.

I need to count all Headers2 inside of Header1. I mean, all number of
headers when Header1 is A and/or when it's B.

Please help me. :)

Regards,
Marco
Click to expand...
Click to expand...
 
Marco said:
Hi. In my report I've got a Header1 and Header2.

First come Header1 in where I've got most of the times two possibilities, A
or B.

Then I've got several Headers2 inside of each Header1.

I need to count all Headers2 inside of Header1. I mean, all number of
headers when Header1 is A and/or when it's B.
Click to expand...


Add a text box (named txtHdr2) to header2. Set its
ControlSource to =1 and RunningSum to Over Group

Then you can use another text box in the outer group's
footer section with the expression =txtHdr2
 
Marco said:
Hi. In my report I've got a Header1 and Header2.

First come Header1 in where I've got most of the times two possibilities, A
or B.

Then I've got several Headers2 inside of each Header1.

I need to count all Headers2 inside of Header1. I mean, all number of
headers when Header1 is A and/or when it's B.
Click to expand...


Add a text box (named txtHdr2) to header2. Set its
ControlSource to =1 and RunningSum to Over Group

Then you can use another text box in the outer group's
footer section with the expression =txtHdr2
 
Back
Top