Totals

[Roger Bell]

A have a Form which consists of 2 subforms. The two subforms are displayed
in Data Sheet view. I have footers on the subform to total certain currency
fields. The problem is that when these subforms are displayed in data Sheet
view, you cannot see the totals. Is there any way that you can have the
totals displayed in Data Sheet view?

Thanks for any help

 

[Allen Browne]

Several possible solutions:

a) Access 2007 can shows the totals at the foot of a datasheet. Previous
versions cannot.

b) Can you use Continuous View instead of Datasheet? You can arrange the
text boxes side-by-side like a datasheet, with the captions in the Form
Header and the totals in the Form Footer.

c) Alternatively, if you have the totals in the Form Footer (but not showing
because it's in Datasheet view), you can place a text box on the main form,
and set its ControlSource to (say):
=[Sub1].[Form]![Text1]
substituting your subform name for Sub1, and the total text box name for
Text1.

The last solution has problems if there are no records and no new record can
be added:
http://allenbrowne.com/RecordCountError.html