easy when you know how!!

[Ross Hamilton]

I have a small problem with a DB that I'm sure we have all had at some time,
but for the life of me can not fix it.

I have a Main Form with 2 Subforms inside it (linked), on the bottom of each
of the subforms is a total Field eg: =sum(Materials), =Sum(Labour) on the
Main Form I have a Grand Total which is based on the subform totals
=([Materials]+[Labour]), sometimes there is NO labour or NO materials for
the job and the Grand Total does not display.

Can anyone help?

Ross

[Keith Wilby]

"Ross Hamilton" <oz****@hotmail.com> wrote:

I have a Main Form with 2 Subforms inside it (linked), on the bottom of
each of the subforms is a total Field eg: =sum(Materials), =Sum(Labour)
on the Main Form I have a Grand Total which is based on the subform
totals =([Materials]+[Labour]), sometimes there is NO labour or NO
materials for the job and the Grand Total does not display.

If I'm understanding you correctly I think you need to handle null values
(perhaps convert them to zeros in an in-line if?).

Regards,
Keith.

[fredg]

On 15 Oct 2004 09:23:47 +0100, Keith Wilby wrote:

"Ross Hamilton" <oz****@hotmail.com> wrote:

I have a Main Form with 2 Subforms inside it (linked), on the bottom of
each of the subforms is a total Field eg: =sum(Materials), =Sum(Labour)
on the Main Form I have a Grand Total which is based on the subform
totals =([Materials]+[Labour]), sometimes there is NO labour or NO
materials for the job and the Grand Total does not display.

If I'm understanding you correctly I think you need to handle null values
(perhaps convert them to zeros in an in-line if?).

Regards,
Keith.

Look up the Nz()) function in VBA help.

=Sum(Nz([Material],0) + Nz([Labour],0))
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Ross Hamilton]

Worked like a charm thanks very much.

Ross
"fredg" <fg******@example.invalid> wrote in message
news:11****************************@40tude.net...

On 15 Oct 2004 09:23:47 +0100, Keith Wilby wrote:

"Ross Hamilton" <oz****@hotmail.com> wrote:

I have a Main Form with 2 Subforms inside it (linked), on the bottom of
each of the subforms is a total Field eg: =sum(Materials), =Sum(Labour)
on the Main Form I have a Grand Total which is based on the subform
totals =([Materials]+[Labour]), sometimes there is NO labour or NO
materials for the job and the Grand Total does not display.

If I'm understanding you correctly I think you need to handle null values (perhaps convert them to zeros in an in-line if?).

Regards,
Keith.

Look up the Nz()) function in VBA help.

=Sum(Nz([Material],0) + Nz([Labour],0))
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.