If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show phrase when no data for a report
I have followed several threads on this subject which suggest using the IIf
statement in a new text box. Some suggest the IIf should be on a particular field and some suggest on the report itself. I am unable to get the required result and wonder when using a text box for the control source (to enter the IIF statement in to), where it should be placed on the report. Specifically my report is named "DR Diving Record Rpt" and a field from it is "ship" I have tried adding a text box with the following =IIf([DR Diving Record Rpt].[Report].[HasData], Null, "No ships today") and also tried =IIf([Ship] Is Null, "No Ships today", [Ship]) Any help please, thanks |
#2
|
|||
|
|||
Show phrase when no data for a report
|
#3
|
|||
|
|||
Show phrase when no data for a report
FloodEbb wrote:
I have followed several threads on this subject which suggest using the IIf statement in a new text box. Some suggest the IIf should be on a particular field and some suggest on the report itself. I am unable to get the required result and wonder when using a text box for the control source (to enter the IIF statement in to), where it should be placed on the report. Specifically my report is named "DR Diving Record Rpt" and a field from it is "ship" I have tried adding a text box with the following =IIf([DR Diving Record Rpt].[Report].[HasData], Null, "No ships today") That should work if the text box is on the main report and [DR Diving Record Rpt] is a subreport control in the same section. Note that the name of the subreport control may be different from the name of the report object it contains. Since you did not mention a subreport, I am wonering if all this is happening on a single report. If so, the expression should be: =IIf(Report.HasData, Null, "No ships today") -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
Show phrase when no data for a report
Many thanks to you both, I now have the required results.
It does all boil down to getting the correct code in a text box on the correct part of the report (or sub-report) "FloodEbb" wrote: I have followed several threads on this subject which suggest using the IIf statement in a new text box. Some suggest the IIf should be on a particular field and some suggest on the report itself. I am unable to get the required result and wonder when using a text box for the control source (to enter the IIF statement in to), where it should be placed on the report. Specifically my report is named "DR Diving Record Rpt" and a field from it is "ship" I have tried adding a text box with the following =IIf([DR Diving Record Rpt].[Report].[HasData], Null, "No ships today") and also tried =IIf([Ship] Is Null, "No Ships today", [Ship]) Any help please, thanks |
Thread Tools | |
Display Modes | |
|
|