Reports can contain multiple running sum fields. You could, for instance, keep a running sum to
show the number of items packed in each box of a multiple-box order while another running sum
counts the number of boxes. The running sum starts at 0 (zero), hence the need to initialize it to 1
in the Control Source property on the Property Sheet.
You can also assign a running sum within each group by setting the RunningSum property of the
unbound text box to Over Group instead of Over All. In this case, the running sum will start at
zero for each group. Therefore, be sure to set the ControlSource property of a group??™s running
sum to 1.
Add Bullet Characters
You can add bullet characters to a list instead of numbers, if desired. Rather than use a separate
field for containing the bullet, however, it??™s easier to simply concatenate the bullet character to the
control??™s RecordSource property. Access will ???glue??? the bullet character to the data as it is displayed
on the report, eliminating alignment problems that might occur with a separate unbound
text box.
Pages:
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301