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

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
 
G

Gary Miller

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
________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report w/same number of duplicate identical pages as there are records 7
How to display a message "form" if report has no records 10
How to Make Column Name Disappear if no values in column 2
how to disregard value in record if null? 4
Last record of crosstab repeats in report 11
How to squeeze out vertical space in a report section 6
Joining data from 6 tables so I can produce a report. 1
Crosstab report repeats last record for all values 10

Top