T-shirt Sizes

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?

On Jul 12, 2:39*pm, ampickel
wrote:
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?

Wrong design.

Try
Size, Quantity, CustomerID

then it's trivial.

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

--
Duane Hookom
Microsoft Access MVP


" wrote:

On Jul 12, 2:39 pm, ampickel
wrote:
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?

Wrong design.

Try
Size, Quantity, CustomerID

then it's trivial.