So I have much larger database (1200+) but am struggling to put together this query.
I need to know how many t-shirts of each size, in each color, sorted by "print" and excluding withdraw.
Because of the wordpress-download to excel-upload to access, and then ordering "more later," I'm stuck with the format in this of the size given and then adding extra shirts as they order them.
I have teams (like Ice Crew) who I need to pass on size to but I don't order for. I can't have those shirts in the total.
People will withdraw and I need to make sure those don't get ordered.
I hope this makes sense.
I'm just so confused!!!
I need to know how many t-shirts of each size, in each color, sorted by "print" and excluding withdraw.
Because of the wordpress-download to excel-upload to access, and then ordering "more later," I'm stuck with the format in this of the size given and then adding extra shirts as they order them.
I have teams (like Ice Crew) who I need to pass on size to but I don't order for. I can't have those shirts in the total.
People will withdraw and I need to make sure those don't get ordered.
I hope this makes sense.
I'm just so confused!!!