Solved Adding total row to subform (1 Viewer)

[JamieRhysEdwards]

Hi All,

I'm trying to replicate the Contact Details Form which is found in the Asset Database template. Within the Asset portion of the form, their subform has a total bar:

I'm trying to replicate this within my asset database, I cannot find how this was achieved at all. my properties match theirs, my design view is also matching and I cannot see how they've achieved this.

 

[jdraw]

See if this subform youtube video by Dr. Verschurren applies. He goes through the set up ~ 6 min mark.

 

[strive4peace]

hi @JamieRhysEdwards

when you're in the datasheet, click the Totals button in the Records group of the Home ribbon -- this toggles the display of the Totals row on and off

 

[JamieRhysEdwards]

Thank you @strive4peace, that was exactly what I was looking for! I didn't even bother looking at the ribbon at all!

 

[strive4peace]

you're welcome, @JamieRhysEdwards ~ happy to help