RJGoodhead
Registered User.
- Local time
- Today, 05:18
- Joined
- Feb 16, 2012
- Messages
- 14
Hi all, I'm building a form. It's based upon a table "Orders", within this is an "Invoices" subform (Datasheet).
Each entry in the subform has a type (text) and a value (currency).
My aim is to display to the totals at the bottom of the parent form in a text box. The catch is I need 3 totals:
Total for "Type1"
Total for "Type2"
Total for All others
I also want to be able to sum these 3 text boxes to 2 records in the parent, so another subform would not help.
I created a few queries that create the results, but have no idea whether this is useful at all as I haven't been able to make them work with a text box
I've been searching for a while now but can't find anything that seems to tackle this.
I have almost no experience with form building and would be extremely grateful for any suggestions on this.
Hope I've explained this well, Thanks Richard
NB I am hoping for a quick resolution so have posted to 2 forums at the same time. I respect your time and will update my issue is resolved. I hope this does not put you off helping. ht tp://forums.aspfree.com/microsoft-access-help-18/diplaying-specific-totals-from-a-subform-table-on-the-parent-498442.html
Each entry in the subform has a type (text) and a value (currency).
My aim is to display to the totals at the bottom of the parent form in a text box. The catch is I need 3 totals:
Total for "Type1"
Total for "Type2"
Total for All others
I also want to be able to sum these 3 text boxes to 2 records in the parent, so another subform would not help.
I created a few queries that create the results, but have no idea whether this is useful at all as I haven't been able to make them work with a text box
I've been searching for a while now but can't find anything that seems to tackle this.
I have almost no experience with form building and would be extremely grateful for any suggestions on this.
Hope I've explained this well, Thanks Richard
NB I am hoping for a quick resolution so have posted to 2 forums at the same time. I respect your time and will update my issue is resolved. I hope this does not put you off helping. ht tp://forums.aspfree.com/microsoft-access-help-18/diplaying-specific-totals-from-a-subform-table-on-the-parent-498442.html