Text box default value.

[needadvice]

I run a report with weekly and yearly currency amounts. Two fields with identical property settings pull the same data from different time periods. At present no data exits. When I run the report ,one field comes up with $0.00. The other comes up blank. What determines this? I want both fields to come up with $0.00.
Very puzzling since I see no difference in these fields.

 

[SarahG]

Check the format of these fields in your report.
If they are the same, then check the data ... if it is the yearly figure showing blank then chances are some of the underlying data is null and doesn't fall in the time period for the weekly field. In this case, ensure the underlying field is a numeric one.

 

[needadvice]

Thanks for the tips. I tried each one and it made no difference. All things seem to be equal but the fields display differently.