sum in subform footer not working

  • Thread starter Thread starter Di
  • Start date Start date
D

Di

I am new to using sums and not sure if I am doing something wrong, this is
what I have set up and my text box is returning blank although there is data
in some records of the subform already
=Sum([fieldname]/60+[fieldname]-[fieldname])
 
If any one of these fields is null, the expression will be null.

Perhaps you want something like this:
=Sum(Nz([fieldname],0)/60 + Nz([fieldname],0) - Nz([fieldname],))
 
Thank you so much, can't believe I wasted so much time trying to figure it
out yesterday!

Allen Browne said:
If any one of these fields is null, the expression will be null.

Perhaps you want something like this:
=Sum(Nz([fieldname],0)/60 + Nz([fieldname],0) - Nz([fieldname],))

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

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


Di said:
I am new to using sums and not sure if I am doing something wrong, this is
what I have set up and my text box is returning blank although there is
data
in some records of the subform already
=Sum([fieldname]/60+[fieldname]-[fieldname])
Click to expand...
Click to expand...
 
Back
Top