Without know what fields/tables represent - "I need a list that shows all 1st Grade review Period 1 students (First Name, Last Name and Grade) and then their Period 2 class", my guess is that you'll have possibly 2 (or 3 queries).
Using Query Designer! (much easier versus trying to code this directly), Create your first query which has the criteria in it to just retrieve the records to show 1st Grade Students Making sure the ID field is in the query. Then create a 2nd query which has the ID field in one of the tables (buy not the same table used in the 1st query - ie. the table the 1st query would join to) with criteria for their Period 1 or 2 classes (again - you need the ID field which is going to link both these queries together in the final query (where you'll add both the 1st and 2nd query linking by that ID field). You "may" be able to just link the 2nd query into the 1st query but I can't say for sure without more info.
IF the "1st Grade review period" and "Period 2" data is in the same table (ie. classes), then just have 1 query with any tables that link that back to the students table, and then put criteria in that query where the class value = "Period 1" OR "Period 2" (along with criteria where Grade = 1st). But it's confusing on where your data is stored (field/tables) for your request without more info.
Try doing this in the query designer and then select "SQL" (versus Design/Open) to then view the sql statement.
Last edited by pkstormy; 06-05-09 at 02:24.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)