KINGOFCHAOS17
Member
- Local time
- Today, 04:04
- Joined
- Mar 20, 2020
- Messages
- 31
In need of some assistance with creating a report. I know what I want, but not sure where to begin. I've five fields in my table (see sample data) and I would like to group by field 'SNOW' and then check the status of field 'LINE STATUS'. So for example SNOW (or order) 1, 24, 200, and 338 at the group level would show as COMPLETE, whereas 167, 199, and 4416 would show as INCOMPLETE as either one or all of all the lines against the order have not been received from the supplier.