Blank Values in Report

[balajigade]

I have two issues with the report generation from a query:



(i) Sometimes blank values appear in the report in the serial number column generated dynamically (setting the control source property =1 and running sum = overall), but when clicked inside the particular box, the correct serial number appears

(ii) When grouped on a field, the particular field value appears sometimes more than once in the report inside the same group.


How to get rid of this?

[ranman256]

duplicates can show if you have grouping and duplicate boxes with the field
or
change the query property to UNIQUE VALUES = yes
or
if the field = null getting summed , youll get null