Good day experts,
Here I am again seeking help for the access database I am trying to create.
Attached is my main form, what I wish is that SUBTOTAL will be displayed in the 1st subform (LOT) from the total of 2nd subform (LOT DETAILS). Then from the total in 1st subform, a grand total will be displayed in the main form.
Hope this is possible, I have been searching but cannot find any solutions. I can only find a grand total from single subform...
Here I am again seeking help for the access database I am trying to create.
Attached is my main form, what I wish is that SUBTOTAL will be displayed in the 1st subform (LOT) from the total of 2nd subform (LOT DETAILS). Then from the total in 1st subform, a grand total will be displayed in the main form.
Hope this is possible, I have been searching but cannot find any solutions. I can only find a grand total from single subform...