I have the same problem but not that complicated. So do anyone know how to subtotal only one field value in subform? I only found sum which only used for table but I didn't found functions for subtotal a field in subform. If possible can anyone give me a simple sample for the function of subtotal? (I am just a poor business consultant who was trying to code in Adobe, so this request may seems **bleep**) Very appreciate. Thanks!