IIF STATEMENT

[Fred's]

Hello folks,


I will like to create a IIF statement, because if there is no records
entered, between a starting date and a ending date, I will like that
my report show something like this: "No records for this period"

Hope that somebody can help me with this...

Thank you all in advance for your help and support.

Fred's

 

[Guest]

Hi

You mention reports so I asume you are looking a way to cancel a report
after dsiplaying a message to a user ??

You can use the report's On No Data event (in the properties box)

MsgBox "No records for this period."
Cancel = True

 

[Fred's]

Hi Wayne,

Thanks for the tips, but this is not exactly what I'm searching for.
I'm searching a way to see this sentance "No records for this period."
directly on my report, and not as a Msg box.

Thanking you in advance for your continuous help!

Fred's

 

[Bob Quintal]

Hi Wayne,

Thanks for the tips, but this is not exactly what I'm
searching for. I'm searching a way to see this sentance "No
records for this period." directly on my report, and not as a
Msg box.

Thanking you in advance for your continuous help!

Fred's

So add a label on your report header that says that.
Set its visible property to MO. use the on no data event to
change the visible property to yes.