expressions not working in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Ifnull expression I use in my forms to set unused fields to 0
(otherwise summations, etc get errors in calculations for null fields). This
works great for forms, but it will not work in reports. I keep getting #
errors. Any help would be much appreciated.
 
I have a Ifnull expression I use in my forms to set unused fields to 0
(otherwise summations, etc get errors in calculations for null fields). This
works great for forms, but it will not work in reports. I keep getting #
errors. Any help would be much appreciated.
Click to expand...

Without seeing your expression it's not possible to comment upon it.

However, did your try:
=Nz([FieldName],0)

Look up the Nz function in VBA help.
 
I have a Ifnull expression I use in my forms to set unused fields to 0
(otherwise summations, etc get errors in calculations for null fields). This
works great for forms, but it will not work in reports. I keep getting #
errors. Any help would be much appreciated.
Click to expand...

Without seeing your expression it's not possible to comment upon it.

However, did your try:
=Nz([FieldName],0)

Look up the Nz function in VBA help.
Click to expand...

I forgot to add make sure the name of the control is not the same as
the name of the field in it's control source expression.
 
Back
Top