Inclusive Query with multiple criteria

[Jet1234]

Hi,



I'm trying to stay away from a complex UNION query in Access. All I need is an output query where a student could pass a 495 course, or pass both 485 AND 425.

[ranman256]

make a table with the grade range

grade, MinPts, MaxPts
A, 425, 495
B, 300, 424
etc

then a query to pull the final amts table vs the range table to get the grade.