T Shirt totals

[PeggyC09]

Please note I have limited time in the office but need some help with this. I PROMISE to get back to this thread.... as soon as possible.

I'm trying to figure out how to submit an order for shirts from a table that has name, size, and extra shirts. SIMPLE!

I have to create a doc to send to the company for shirt orders. (see attached spreadsheet that was calculated manually)


I can create a query that adds up the number of small shirts. But I don't know how to create one that adds up smalls, and mediums and larges separately (like the attached spreadsheet which was done manually). Can I calculate for the different sizes in one query? I have tried to use a calculated field but it keeps returning an error.

 

[PeggyC09]

I will try that. Still trying to figure these out.

 

[arnelgp]

simple sample for you, view query1

 

[PeggyC09]

This is amazing! I'm working through how you did it. (I only work Thursdays).

simple sample for you, view query1

 

[PeggyC09]

I took this sample (which was almost perfect....) and I made some changes. If you look at it, the notable changes are I added 2 fields in the personnel table. First the "role" and then the "print." These are essential for the order since Staff (role) gets a blank (print) pink shirt.

I'm confused how to get this query to tell me how many supervisor shirts and volunteer shirts I will need for beer garden.

The structure of this shirt order is
Color (4 colors)... then "print" (determined by role)
All colors have at least 2 different things printed. (pink has 6)

Help! This is tough for a newbie!

simple sample for you, view query1

 

[PeggyC09]

OK... thanks for your patience if you were helping! I think I got it after more studying it! Thank you so much!