The data for this form is coming from one query.
I have a list box that shows all Lot_ID records and one can select multiple.
I then have a button that brings up a form that only brings the records where the Lot_ID matches the selections.
Next i want to combine only the fields Name, WidthString, LengthString, MaterialName, and QTY (SUM).
As you can see in form there are several lines where all 5 fields match, but they're done combined since Lot_ID is different.
From this form, i want to create a report that combined these 5 fields and sum's QTY but ignores Lot_ID
I have a list box that shows all Lot_ID records and one can select multiple.
I then have a button that brings up a form that only brings the records where the Lot_ID matches the selections.
Next i want to combine only the fields Name, WidthString, LengthString, MaterialName, and QTY (SUM).
As you can see in form there are several lines where all 5 fields match, but they're done combined since Lot_ID is different.
From this form, i want to create a report that combined these 5 fields and sum's QTY but ignores Lot_ID
Last edited:
