Display records based on conditions in multiple fields in Access

[Guest]

I want to create a report that will return a student's record based on
whether a condition (<50%) is true for multiple fields.

 

[MGFoster]

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

 

[Guest]

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.

 

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