New User (1 Viewer)

R

rmsimps

New member

Local time

Today, 10:33

Joined

Apr 7, 2019

Messages

6

• Apr 7, 2019

• #1

I am a new user to the forum. I am looking how to usie IIF in a report so that it will print the output depending on the boolean value.

 

M

Micron

AWF VIP

Local time

Today, 13:33

Joined

Oct 20, 2018

Messages

3,478

• Apr 7, 2019

• #2

Not much to go on. Perhaps you mean if the report has no records, then don't open/print,or display a message. If it's a boolean value based on the underlying record source, then usually the filtering of records is best done by the query. If no records, you're back to using the OnNoData event that I alluded to.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 10:33

Joined

Oct 29, 2018

Messages

21,454

• Apr 7, 2019

• #3

Hi. Welcome to the forum! You must be referring to this thread. I think it's better to continue the discussion there.