Count In Report Footer

[CharlesWilliams]

I am trying to get a total count of the source for 2 different items in the report footer and cannot seem to figure out the correct code.

Please see the attached file to see what I am asking.

Any help would be greatly appreciated.

- Charles Williams

 

[RichO]

An answer can't be given based on the information you've provided.

In your table what field determines whether a record is "yellow book" or "super pages"?

Your count would have to be based on that field.

 

[CharlesWilliams]

Hi RichO,

I'm sorry for the lack of a response. I was out of work because of illness.

Yes, I see now that it is trying to count 2 fields that are not there. I excluded the details area because my boss did not need to every record. Is there a way to have it count the SourceShort Footer ???

Thanks for all your help.

- Charles Williams

 

[RichO]

You can count in a group footer but it somewhat depends on how things are formatted. What field in your table designates yellow book or super pages?

Are you able to post a sample of your DB?

 

[CharlesWilliams]

Re:

Hello Again,

I can't use the company database so I will make a dummy database to show you what I am trying to aqccomplish...

Give me a little bit to get it together.

- Charles Williams

 

[CharlesWilliams]

Sample

Here's a sample of what I'm trying to accomplish...

 

[RichO]

Hopefully this is what you want:

I put 2 non-visible text boxes in the SourceShort footer, one with a running sum of YellowBook and one with a running sum of SuperPages. I used the IIf function and InStr to look for the words "Yellow" or "Super" in the SourceShort field and count conditionally.

Then I simply grabbed the values from the running sum fields and put them in the report footer.

 

[CharlesWilliams]

Rich,

Thanks a million. I like you solution and plan to keep it for future projects. It's neat to see 1 problem and multiple solutions. Attached is another solution I found.

Again Thanks A Million !!!