E
Ed S.
Hi all,
This is one of those things that I should know, but just can't remember
right now.
I'm creating a database for an extra-curricular program that will allow it
to track all of its students. One of the fields that they are tracking is
T-Shirt Size. [tshirt] The T-Shirt sizes are a drop-down menu that they are
able to change if they need to. The values are contained in a separate table.
I've got a report which shows all the students by class and also by
division. I'm trying to figure out how to have the report count how many of
each size of shirt is needed. What I don't want to do is say, "Count how
many Child-Small", but rather identify each of the fields in the t-shirt size
table and count them.
I tried to do this while using the report wizard, but it never gave me the
option.
Thanks!
Godspeed,
Ed
This is one of those things that I should know, but just can't remember
right now.
I'm creating a database for an extra-curricular program that will allow it
to track all of its students. One of the fields that they are tracking is
T-Shirt Size. [tshirt] The T-Shirt sizes are a drop-down menu that they are
able to change if they need to. The values are contained in a separate table.
I've got a report which shows all the students by class and also by
division. I'm trying to figure out how to have the report count how many of
each size of shirt is needed. What I don't want to do is say, "Count how
many Child-Small", but rather identify each of the fields in the t-shirt size
table and count them.
I tried to do this while using the report wizard, but it never gave me the
option.
Thanks!
Godspeed,
Ed