Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Correenie

    Keep rows in a Group together, but not on a new page per Group

    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
  2. Correenie

    Adding transparent and color to IIf function that already has 4 condit

    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...
  3. Correenie

    Add 2 colors to an IIf function that already has 4 conditions

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

    Add 2 colors to an IIf function that already has 4 conditions

    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...
  5. Correenie

    Start report weeks on Fridays, display dates for the week

    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...
  6. Correenie

    Start report weeks on Fridays, display dates for the week

    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...
  7. Correenie

    =Count(IIf([ works for one field, but not another

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

    =Count(IIf([ works for one field, but not another

    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?
  9. Correenie

    =Count(IIf([ works for one field, but not another

    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...

Part and Inventory Search

Back
Top