Sub Total [message #423714] |
Sun, 27 September 2009 03:29  |
mat_vargh@yahoo.com
Messages: 1 Registered: September 2009
|
Junior Member |
|
|
Hi,
I have a form with 4 column...
Eg., Company, Brand, Item, qty.
I want to show the subtotal for each brand (for the qty field) in this form. Please advise.
Thanks in advance.
|
|
|
Re: Sub Total [message #423737 is a reply to message #423714] |
Sun, 27 September 2009 12:49  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
How do you "imagine" that form? It appears that number of items may differ, which means that you can not "dynamically" move that "subtotal" item throughout the form. Moreover, where would you put it if a certain brand contains more items than records on a page?
Though, perhaps you could create a single "subtotal" item (for a current brand - the one that has focus on it) and calculate its value in a PRE-RECORD trigger (for example).
|
|
|