|
| 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
February 2nd, 2007, 08:40 PM
posted to microsoft.public.access.reports
|
|||
|
|||
#error
Hi,
I can't understand why I am getting the following error: #error in a report, I am trying to show null if column = zero. Like this: =IIf([Rev H&W]="0",Null,[Rev H&W]) thanks in advance Ismail -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200702/1 
|
|
#2
February 2nd, 2007, 08:53 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#error
Remove the quotes around your zero. The quotes means that you are testing
for the character zero, rather than the number zero. "ielmrani via AccessMonster.com" wrote: Hi, I can't understand why I am getting the following error: #error in a report, I am trying to show null if column = zero. Like this: =IIf([Rev H&W]="0",Null,[Rev H&W]) thanks in advance Ismail -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200702/1
|
|
#3
February 2nd, 2007, 08:58 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#error
thanks for your quick reply. I also solved it by putting the code in the
query instead of the report. Pendragon wrote: Remove the quotes around your zero. The quotes means that you are testing for the character zero, rather than the number zero. Hi, I can't understand why I am getting the following error: #error [quoted text clipped - 3 lines] thanks in advance Ismail -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200702/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
