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

Similar Threads


Top