Search results
-
K
Create a numerical sequence based on second field
Have two tables: Assignment and StudentHeader - they are related by AssignmentGUID Have the SQL: SELECT StudentHeader.[Student ID], StudentHeader.GUID FROM Assignment INNER JOIN StudentHeader ON Assignment.GUID = StudentHeader.[Assignment GUID] WHERE (((Assignment.[Assignment Type])="Q") AND...