S
Steve@EdSmart
I want to create a report that will return a student's record based on
whether a condition (<50%) is true for multiple fields.
whether a condition (<50%) is true for multiple fields.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Display records based on conditions in multiple fields in Access
M
MGFoster
Steve@EdSmart said:I want to create a report that will return a student's record based on
whether a condition (<50%) is true for multiple fields.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That's a vague specification.
Criteria for queries is stated in the WHERE clause:
SELECT ...
FROM ...
WHERE student_grade < 0.5
or
WHERE student_grade < 0.5
OR student_attendance < 0.5
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRJ2fIYechKqOuFEgEQJOVwCg3coC8Mjag89OSU0qx9qAxFbnNo0AoOJt
Fgak23oFQjtKts0mWzSV4XQA
=5ZEn
-----END PGP SIGNATURE-----
S
Steve@EdSmart
Yes, I was vague but I'm a newbie.
I'm attempting to manipulate records in a database that contains student
achievement data. The student achievement data is broken down into multiple
strands (objectives). So, I have columns for Strand 1, Strand 1 Concept 1,
Strand 2, Strand 3, etc.
The report I'm attempting to create will select those students who score
below 50% on any one of the strands. Further, if the student scores below 50%
on, for example, Strand 1, the report will display the Student's name,
Teacher, Grade and the values for the Strand and Strand x-Concept 1, Strand
x-Concept 2, etc. The number of concept colums varies by subject and strand.
Thank you for your assistance.
I'm attempting to manipulate records in a database that contains student
achievement data. The student achievement data is broken down into multiple
strands (objectives). So, I have columns for Strand 1, Strand 1 Concept 1,
Strand 2, Strand 3, etc.
The report I'm attempting to create will select those students who score
below 50% on any one of the strands. Further, if the student scores below 50%
on, for example, Strand 1, the report will display the Student's name,
Teacher, Grade and the values for the Strand and Strand x-Concept 1, Strand
x-Concept 2, etc. The number of concept colums varies by subject and strand.
Thank you for your assistance.
D
Duane Hookom
I suggest you normalize your table structure. Each "achievement data" value
should create its own record rather than using multiple strand fields. Your
query would then be much easier.
If we had a clue how your strands and concepts were related, we could
suggest a better table structure. If it is impossible to change your
structure, someone could provide the SQL view of a union query that might
work for you.
should create its own record rather than using multiple strand fields. Your
query would then be much easier.
If we had a clue how your strands and concepts were related, we could
suggest a better table structure. If it is impossible to change your
structure, someone could provide the SQL view of a union query that might
work for you.