Help with a small problem.

  • Thread starter Thread starter Ross Hamilton
  • Start date Start date
R

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
 
Try:
=Nz([Materials],0) + Nz([Labour],0)

If the subforms are read-only or new records cannot be added, that may still
yield #Errror. Post back if you strike that issue.
 
Worked like a charm, thanks very much.

Ross

Allen Browne said:
Try:
=Nz([Materials],0) + Nz([Labour],0)

If the subforms are read-only or new records cannot be added, that may still
yield #Errror. Post back if you strike that issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ross Hamilton said:
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.
Click to expand...
Click to expand...
 
Back
Top