Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with null value number feild

Status
Not open for further replies.

crsdev

Programmer
Sep 29, 2006
96
US
Hello Friends,
Could someone please tell me how I can assign 0 to a number feiled in a report when it has null value.

I have something like this:

Sales Return NetSales
500 100 400
300
400 500 -100

the formula i have in NetSales is: sales-return(obviously), but when return is null the NetSales also comes out to be null.
 
Go to file menu and click on report option. You can see something like convert database null values to default or other null values to default use that.
 
bubu2006 Thanks for the response
Do i have to assign the Default value somewhere, because that option is turned off when i went to options>reporting
 
Nevermind I got it, was looking at the wrong place.. Thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top