T-shirt Sizes

[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?

 

[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.

 

[Duane Hookom]

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