var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sum a group of records within a field on a form
How do I add a sum to a selection of items within the same field on a form.
Let me explain:-
I have a product field and a quantity field
This is how they currently appear o my form
I have a number of products and I need to show the total of each product.
This is how I want them to appear.
Table Name: ProductsInfo(Product, Qty)
Select ProductsInfo.Product, Sum(ProductsInfo.Qty) as TotalofProduct
Group By ProductsInfo.Product;
Last edited by lansing; 09-24-03 at 10:41.