How conditionally skip stuff on a report?

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
 
J

Jeff Boyce

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

Jeff Boyce

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

Jeff Boyce

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
 
J

Jeff Boyce

We're in agreement, then ...

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

Regards

Jeff B.
 
J

Jeff Boyce

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
 
J

Jeff Boyce

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

John... Visio MVP

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
 
G

Gina Whipp

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
 
J

Jeff Boyce

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

Jeff Boyce

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

Arno R

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

Mark

don't suppose any of you guys/gals have time to look at my post "Report
Footer, multi-column rpt", would you?
Thanks,
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking 2 contacta 1
How conditionally skip stuff on a report? 1
How can I change the recordsource of a report in code? 2
Summing expressions per group in a report 3
How to print a page in between of every report page? 3
How to skip a record in a report? 3
Memo field is truncating in group heading of an Access 2007 report 3
Logo visible on MS Access Report but not when I print to PDF 1

Top