Report has No Records via SQL how to assign zero value for confition

  • Thread starter Thread starter moizee
  • Start date Start date
M

moizee

Dear All,
I have a Report through Query in which sub report has values and vi
subquery some fields has no data i.e. (CONTRACT INFORMATION (Master
and SHIPMENT INFORMATION (Detail).

Some records have master record but no detail record found therefor
some records have CONTQTY not NULL but SHPQTY IS Null.

Now i want if SHPQTY is null then it assigs a value to 0(zero) so th
balance can be caluculated.

KINLDY HELP urgently.
thank you
Moi
 
Moiz,

The use of the Nz() function is what you need I believe.
This converts nulls to zero ( and other values if
specified ). Check it out in Help. You will probably end up
with something similar to...

=Nz([SHPQTY],0)

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top