Report Running Sum Picks Only First Record of Group

[Paul Martin]

I have a report based on a crosstab query. I have 4
groups in the report: The first 2 groups need totals in
its group footer while the last two are merely sorts.

All the detail records properly display on screen, but the
group total textboxes (set Running Sum to "Over Group")
only show the value from first record of the group.

Any ideas? Thanks for your help!

System: Win2000 Pro SP4/Access 2000 SR-1

 

[Allen Browne]

This happens if Access does not understand the field to be numeric.

If your report is based on a query, run the query directly.
Does Access display this field left-aligned (as text) or right-aligned (as
numbers)?

You can force the data type with CLng(), CDbl(), CCur() or whatever. You may
also need to use Nz() to handle nulls.

Alternatively, setting the Format property of the control on the report may
be enough for Access to interpret the data correctly. Try General Number.