Search results

Thanks. I'll try it.

Thank you again Rich bas-bleu! Please see attached with codes, etc. dona

Rich THANK YOU! THANK YOU! IT WORKS! Dona

Rich Here is a sample.

Yes. It is in the Page Footer.

Yes Text box says "Page " & [Page] & " of " & [Pages]

I need help. I used the code below. It works; however, if one group report has only one page. It currently says page 1 of (blank) when I use the code below. I want it to say page 1 of 1. WayneRyan answered my Report post. He suggested adding the following line: Me!ctlgrpPages = " Page " &...

No I couldn't because I was grouping by districts within the 60 page report. For example, District A has 2 pages, District B has 1 page, District C has 10 pages. I wanted District A to say page 1 of 2, page 2 of 2. District B page 1 of 1, etc. Before Wayne's reply, the District B report...

I changed the text a little Me!ctlgrpPages = " Page " & GrpArrayPage(Me.Page) & " of " & GrpArrayPages(Me.Page) +1 Thank you WayneRyan for fixing this part. Any ideas for the other part? WayneRyan was able to help solve part of the problem. (He answered my Report post) Unfortunately, a...

I used the following code. It works; however, one group report has only one page. I want it to say page 1 of 1. I don't know how to write the code and where to put it. It currently says page 1 of .Please help. Thank you. Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant...

In your table add a Count field. Put a 1 for all your records. Add this field to your query. Now you should be able to count your null fields. I hope this helps.

I need help. I created a pie chart in a subreport. The chart is linked to a code. I want to exclude one field out of a record. Each store may have a different inventory. The pie chart may have 45 potatoes, 20 tomatoes, 30 lettuce and 0 green beans. I want to exclude the green beans from...

Pie Chart exclude 0% Hi Rich, If I put Not Is Null or <>0 in the criteria section of the report's underlying query field, would it not exclude the entire record. I just want to exclude one field out of a record. The pie would have 30% carrots, 40% lettuce and 30% tomatoes. The 0% of potatoes...

I need help. I created a pie chart in a subreport. The chart is linked to a code. Every page is different which is what I want. However, I do not want the pie chart to show a 0% when the no response field (or any other field) is zero. After all who wants a pie chart with a 0% as one of the...

I need help. I created a pie chart in a subreport. The chart is linked to a code. Every page is different which is what I want. However, I do not want the pie chart to show a 0% when the no response field (or any other field) is zero. Please help!