T-shirt Sizes


A

ampickel

Ok I know that was a weird title. But this is what I need. I am trying to
tally t-shirts into sizes. So right now my table has names and 7 sizes all
in there own columns. Sizes are YS YM YL AS AM AL AXL. As of right now I
have a 1 in the column of the size the athlete wants. What I am wondering is
if I change the t-shirt column to a lookup with all the sizes can I still do
an individual count of each size. EX. Can I get access to count how many
time the YS comes up, or AM comes up? If so How is this done?
 
Ad

Advertisements

P

pietlinden

Ok I know that was a weird title.  But this is what I need.  I am trying to
tally t-shirts into sizes.  So right now my table has names and 7 sizesall
in there own columns. Sizes are YS YM YL AS AM AL AXL.  As of right nowI
have a 1 in the column of the size the athlete wants.  What I am wondering is
if I change the t-shirt column to a lookup with all the sizes can I stilldo
an individual count of each size.  EX.  Can I get access to count howmany
time the YS comes up, or AM comes up?  If so How is this done?

Wrong design.

Try
Size, Quantity, CustomerID

then it's trivial.
 
Ad

Advertisements

D

Duane Hookom

I agree. The sql view would be something like:
SELECT Size, Sum(Quantity) as NumOf
FROM tblGoodDesign
GROUP BY Size;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top