How conditionally skip stuff on a report?

  • Thread starter Thread starter ray anselmi
  • Start date Start date
R

ray anselmi

Good morning,
I saw the article "How conditionally display stuff on a report?", however I have a slight twist.

I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck.
Thanks!!

EggHeadCafe - Software Developer Portal of Choice
How to detect and Automatically install MSXML
http://www.eggheadcafe.com/tutorial...1-04094072c374/how-to-detect-and-automat.aspx
 
When you say "skip", do you mean "don't show ANY of the fields in a record
that has nothing in the [Comments] field?

If so, use a query! Exclude rows with "blanks" (now the tough part ...
"blank" could mean Null, or zero-length string, or spaces ... they all look
blank to me!). Your query needs to exclude any of those possibilities.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
As asked, the original poster wished to "skip that record", not (merely) the
control/blank...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Steve

Here's a direct quote from the OP - "How do I get the report to skip that
record. "

Yes, the OP also mention the blank..., but asked a direct question about
skipping a record.

My initial response asked the OP for clarification, whether "skip" meant the
entire record or just the field.

Regards

Jeff
 
We're in agreement, then ...

We need to know how the OP is defining his terms to offer an suitable
approach.

Regards

Jeff B.
 
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread" that
you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP
 
Ray

Do you have a solution to your question?


--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
You are paranoid. I was responding to you and only you. So does "done and
over" really mean you are going to stop pimping your services? I doubt it.

John... Visio MVP
 
Steve,

I'd like to know where these MVP Rules of Conduct are, as my awareness is of
the Rules of Conduct that govern these newsgroups... which applies to
everyone, you know the ones you ignore, not just MVP's. Of course, I
probably won't get and answer from you...

Can anyone else tell me where these seperate rules are?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
It's over when and because you say it is?!

How did my response "implicitly criticize" your proposed solution? If you
don't provide an explicit description, how do you expect me to be able to
change my behavior?

I accept responsibility for my posts and behavior. I don't have the power
to "cause ... John" to post.

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
.... and one more thing. Even if my response "implicitly criticized" your
proposed solution, how do you bridge the obvious gap to considering that an
attack?

Are you suggesting that anyone who disagrees with you or criticizes
something you propose is attacking you?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Steve said:
Just like you can't drop it; there was no need to respond to my post as you did other
than to get your dig in me!

Regards,

Steve
Click to expand...

Now who's clinically obsessive here... ??
haha hilarious! You really make my day...

Regards,
Arno R

BTW: You did take your pills ?? I am afraid not ...
 
don't suppose any of you guys/gals have time to look at my post "Report
Footer, multi-column rpt", would you?
Thanks,
Mark
 
Back
Top