By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Show a record on a report NULL if the record is "0"

100+
P: 135
Hello everyone

I have a report showing a field (LEVEL 1 DRIVER) for a list of products. Most of the records for every product are "0". The field is BOUND to table ENGINEERING to a field named the same (LEVEL 1 DRIVER).

In the table i CANT have NULL values and the default value for this field (LEVEL 1 DRIVER) is set to "0". However in the report i feel very confusing having all these "0" around, how can i create an IF function so that if the record is "0" it wont show nothing ("") but if its greater than "0" (>0) it will show the value on the bound control (LEVEL 1 DRIVER from table ENGINEERING)

Help please
Sep 6 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 296
Hello everyone

I have a report showing a field (LEVEL 1 DRIVER) for a list of products. Most of the records for every product are "0". The field is BOUND to table ENGINEERING to a field named the same (LEVEL 1 DRIVER).

In the table i CANT have NULL values and the default value for this field (LEVEL 1 DRIVER) is set to "0". However in the report i feel very confusing having all these "0" around, how can i create an IF function so that if the record is "0" it wont show nothing ("") but if its greater than "0" (>0) it will show the value on the bound control (LEVEL 1 DRIVER from table ENGINEERING)

Help please
Try:
iif([Level 1 Driver]=0,"",[Level 1 Driver])
Sep 6 '07 #2

100+
P: 135
Try:
iif([Level 1 Driver]=0,"",[Level 1 Driver])
Thanks, worked perfectly.
Sep 7 '07 #3

Expert 100+
P: 296
Thanks, worked perfectly.
glad it worked for you!
Sep 7 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.