Search results

Please, some sample code saying to only print the first page? I haven't had any formal training. Many thanks.

I have many reports that my bosses want to see the details for, but when they click the printer icon, they only ever want the first page. What can I do to display all data, but force only the first page to print? Thanks so much, ~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...

I looked at your link, but I'm not sure where to insert the conditions for the colors.

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

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

Hello all! I have a report that groups weeks for me, but I need to modify the dates beyond week 1 of the year, etc. (If you really want to throw me a bone, our week runs Friday-Thursday). The code below works when Access tells *me* the date range, but what if I want to tell *it* what dates to...

Thanks, got the answer Thank you to everyone who gave me advice. This is what finally worked: =Sum(Abs([Combined Income]<70000 And [Combined Income]>1))/Count([Combined Income]) I was told that this is the correct way because: "IIf() should always have 3 arguments and you are using only 2...

"The expression you have entered has a function containing the wrong number of arguments." (Please help).

"The expression you have entered has a function containing the wrong number of arguments." (Please help).

thanks - tried and failed. I have the same field (with the same data) as both Text and Number (I've tried *everything*). I used your code with the number version, but it didn't work. It thinks that all numbers meet the criteria. Combined Income 80000 62000 100000 90000 120000 150000 80000...

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