Multiple field totals in summary report
When I set up my order entry many years ago, I created separate fields
for each invoice line item (qty1, item1, qty2, item2, etc). It seems
more efficient to do this with a portal now, but I'd still like to work
with the data I have.
Creating a summary field for qty1, I can get a quantity total of all products
entered in item1 (sorted by the item number field in my product database),
but I would like a report with the combined quantity total of all items in
both item1 and item2.
Is it possible to add reports or does anyone have a suggestion to accomplish this.
Any help is appreciated.
You can try Sum (qty1; qty2, qty3, qtyN), but really you should be using a related line items table as you already know.