R
Ron Dechiro
I have created a query from 3 different tables. Somtimes
when I run the query because of the selection criteria
there will be no data in some of the fields. This is fine
until I create a report and want to "Sum" the data in
those three fields. If one or more of the fields is blank
the report returns no value. It remains blank. If I have
data in all three fields the formula works fine. The
fields are formated with the "currency" format. I tried
to custimize the format in the table for the fields so
that when the field is empty it would return a zero in
that field when I run the query. It did return a zero,
but my formula still did not work in the report. The
formula in the report is very basic....[A]+ Sum()+Sum
([C]). There will always be a value in field "A".
HELP!! How can I fix this so my report will be correct????
when I run the query because of the selection criteria
there will be no data in some of the fields. This is fine
until I create a report and want to "Sum" the data in
those three fields. If one or more of the fields is blank
the report returns no value. It remains blank. If I have
data in all three fields the formula works fine. The
fields are formated with the "currency" format. I tried
to custimize the format in the table for the fields so
that when the field is empty it would return a zero in
that field when I run the query. It did return a zero,
but my formula still did not work in the report. The
formula in the report is very basic....[A]+ Sum()+Sum
([C]). There will always be a value in field "A".
HELP!! How can I fix this so my report will be correct????