Search results for query: *

Is there a way to print multiple groups on one page, but to force a page-break so that a group's rows aren't separated? I often have a group with 1-4 rows, and while I don't want them separated from their group header, they don't each need their own page. Many thanks, ~Correenie

I asked this question improperly yesterday. I know color can be applied in "Conditional Formatting," but I need the field to be transparent if two of the yes/no fields are No. Here is where I need to add the color: =IIf([Toured]=True,"GT",IIf([Not Qualified]=True,"NQ",IIf([No...

Yes, but there is no transparent option (which is why I wanted to put it in the IIf).

Greetings All! Here is what works: =IIf([Toured]=True,"GT",IIf([Not Qualified]=True,"NQ",IIf([No Show]=True,"NS",IIf([No Tour]=True,"NT",Null)))) I need to make "NQ" appear on top of a light-orange background and "NS" appear on top of a light-blue background. (If impossible, the text to appear...

Thank you for your help -- unfortunately, after much strife, I figured it out yesterday (this, beyond a count of tours, is the VPG per week for a certain resort). I'm posting it here because I had to splice nearly 50 different websites of sample code to make it work in my report. =Sum(IIf([Tour...

Hello all! I have another challenge. Our work week runs Friday-Thursday. I need to create a report called "Tours for January" and instantly have the following things happen: 1) The weeks of the month are separated Friday-Thursday. 2) The date range is displayed for viewers. The "____" in...

Thank you so much! It worked just fine! ~Correenie

Thank you for your reply. I tried it without the quotes, still no luck. I have the same data as both Text and Number. Any other ideas?

Please help if you can. =Count(IIf([His Age]<"31" And [His Age]>"1",1))/Count([His Age]) works fine for giving me the percentage of people who are 30 and under, but =Count(IIf([Combined Income]<"70000" And [Combined Income]>"1",1))/Count([Combined Income]) will not work (in the same report...