Need help designing a query to pull a list of songs based on ranking and the last play date
From what you've shown, each part of the query has unique aspect (only 5* songs, only 4* songs, etc.).

If that's true, I'd build each query on its own, then use UNION ALL to join them together. UNION ALL takes the results of two queries (with the same number and type of columns in the SELECT list), and gives you the results of both as a single result set (add another UNION ALL to do three queries, etc.)

Any sorting necessary must be done last, after the final query, and applies to the full result set.

If separate queries for each rating are advantageous, you could potentially call each query separately.  But especially in Access, UNION ALL queries are more expensive than a single query with a WHERE clause with multiple OR expressions: WHERE (Ranking = 5 AND ...) OR (Ranking = 4 AND ...).

UNION ALL queries are more useful when combing data from "incompatible" sources that cannot be done in a single query.  The Access visual query designer also does not work with UNIONs.