Sum of all entries with the same SN and Item won't work. HELP!
This has been an issue for me the past 5 days now. In my layout I have a portal that contains ITEM <FIELD>, QTY <FIELD>, PREV QTY <FIELD>(PREV for previous quantity) and a TOTAL SUM FIELD. The table (INV RECORD) in my portal is connected to my layout's table (DAILY REPORT) using JobID and Day relationship.
The ITEM FIELD is a dropdown list which contain items I can choose from, and when I choose an item I will type in the QTY (quantity) value for today's report and that will be added to the value of the PREV QTY. If there is an item with the same JobID regardless of the day (yesterday or days before the current day), the PREV QTY will have the value of QTY from the previous Item.