#Error in total fields of form

[Norbert Meiss]

Hi,
how can I avoid the appearing of #Error in the total field in a form footer.
It is a calculated field like =sum(Invoice) and shows correctly in the first
place and #Error after resorting the form.
Thanks in advance.
Norbert Meiss

 

[ashg657]

If this is a case of an empty recordset resulting in the #Error then place
the following in the control sources of your concerning objects:

Iif([HasData],Sum([Invoice]),"0.00")

HTH

 

[Norbert Meiss]

Unfortunately not. Any record contains a valid value. The #error appears
after resorting.

If this is a case of an empty recordset resulting in the #Error then place
the following in the control sources of your concerning objects:

Iif([HasData],Sum([Invoice]),"0.00")

HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)

Hi,
how can I avoid the appearing of #Error in the total field in a form footer.
It is a calculated field like =sum(Invoice) and shows correctly in the first
place and #Error after resorting the form.
Thanks in advance.
Norbert Meiss

 

[ashg657]

The only thing I can suggest is requerying the calculated field. For example,
after your re-sorting in VBA coding type the following line:

YourControl.Requery

Other than that, I dont know, I'm sure someone else will respond on here
shortly...

HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)

Unfortunately not. Any record contains a valid value. The #error appears
after resorting.

If this is a case of an empty recordset resulting in the #Error then place
the following in the control sources of your concerning objects:

Iif([HasData],Sum([Invoice]),"0.00")

HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)

Hi,
how can I avoid the appearing of #Error in the total field in a form footer.
It is a calculated field like =sum(Invoice) and shows correctly in the first
place and #Error after resorting the form.
Thanks in advance.
Norbert Meiss

 

[Norbert Meiss]

Hi,
thanks for your reply. Actually I cannot find a point (or event) where to
requery the control since we don't use VBA, but the contect menu commands for
resorting...
Maybe I should mention that we use SQL Server 2000 as underlying database
but I cannot see that this would make a difference.
Regards,
Norbert

The only thing I can suggest is requerying the calculated field. For example,
after your re-sorting in VBA coding type the following line:

YourControl.Requery

Other than that, I dont know, I'm sure someone else will respond on here
shortly...

HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)

Unfortunately not. Any record contains a valid value. The #error appears
after resorting.

If this is a case of an empty recordset resulting in the #Error then place
the following in the control sources of your concerning objects:

Iif([HasData],Sum([Invoice]),"0.00")

HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)


:

Hi,
how can I avoid the appearing of #Error in the total field in a form footer.
It is a calculated field like =sum(Invoice) and shows correctly in the first
place and #Error after resorting the form.
Thanks in advance.
Norbert Meiss