S
Shoelaces
I am trying to build what I think is a simple database. It will be used to
track how frequently students wear a school uniform. Up until now, this
information has been gathered by hand.
Presently, I have two tables:
Homeroom: master list of homeroom numbers (key)
Uniform_Records: auto id (key), homeroom (linked to Homeroom table), Date
(captured as the timestamp), Present (records # of students present),
in_uniform (records how many students were in uniform that day)
Teachers will submit this information via our intranet.
What I am trying to do now is build the queries which I can use to display
the results via a web page.
What I want to be able to do is list each homeroom and the percentage of
students who wore the uniform for the week. A couple of things for me to
consider:
1. I would like this to be a running results table. This query would be set
up each Monday so classes could see the results throughout the week.
2. Should a homeroom not submit its data, the homeroom should still be
listed with a 0%.
I envision the results looking like:
Percentage of Students Wearing Uniforms
Homeroom %
01 43
02 53
03 68
04 23
05 0
06 48
etc.
Can this be created in one query or will I need multiples? Can someone help
me along?
I do not seem to be able to even get the counts by homeroom, let alone the %
per homeroom.
I would appreciate any help you can provide.
track how frequently students wear a school uniform. Up until now, this
information has been gathered by hand.
Presently, I have two tables:
Homeroom: master list of homeroom numbers (key)
Uniform_Records: auto id (key), homeroom (linked to Homeroom table), Date
(captured as the timestamp), Present (records # of students present),
in_uniform (records how many students were in uniform that day)
Teachers will submit this information via our intranet.
What I am trying to do now is build the queries which I can use to display
the results via a web page.
What I want to be able to do is list each homeroom and the percentage of
students who wore the uniform for the week. A couple of things for me to
consider:
1. I would like this to be a running results table. This query would be set
up each Monday so classes could see the results throughout the week.
2. Should a homeroom not submit its data, the homeroom should still be
listed with a 0%.
I envision the results looking like:
Percentage of Students Wearing Uniforms
Homeroom %
01 43
02 53
03 68
04 23
05 0
06 48
etc.
Can this be created in one query or will I need multiples? Can someone help
me along?
I do not seem to be able to even get the counts by homeroom, let alone the %
per homeroom.
I would appreciate any help you can provide.