1. I am creating a stores picking list this requires the following user input
1a. Product Code (selected on a form via a combobox)
1b. Assembler Name (selected on a form via a combobox)
1c. Quantity (entered manually)
2. This fills a (temporary) table (contents deleted prior to each new picking list being created) with the following data.
2a. Product, Component, Qty. (there are others but these are the most significant)
2b. This section works fine so far!
3. If more than one product has the same component it obviously enters a row per component per product. I would like to see a total qty with just one component per row.
4. I have tried using the view total option but when I try to change the “Group by” to “Sum” in the Component column I get a “data type mismatch in criteria expression.”
Is there something obvious I am missing?
TIA Cliff
1a. Product Code (selected on a form via a combobox)
1b. Assembler Name (selected on a form via a combobox)
1c. Quantity (entered manually)
2. This fills a (temporary) table (contents deleted prior to each new picking list being created) with the following data.
2a. Product, Component, Qty. (there are others but these are the most significant)
2b. This section works fine so far!
3. If more than one product has the same component it obviously enters a row per component per product. I would like to see a total qty with just one component per row.
4. I have tried using the view total option but when I try to change the “Group by” to “Sum” in the Component column I get a “data type mismatch in criteria expression.”
Is there something obvious I am missing?
TIA Cliff