Hot answers tagged

2

You can either run the following as many times as it takes to get zero rows updated: UPDATE IncentiveAssignments SET PersonID = (SELECT MIN(PersonID) FROM UnassignedPeople up WHERE NOT EXISTS (SELECT 1 FROM IncentiveAssignments WHERE PersonID = up.PersonID) WHERE AutoNum = ( SELECT MIN(AutoNum) FROM IncentiveAssignments WHERE PersonID IS NULL); ...


2

MS Access does not support CASE expressions. The most generic equivalent would be the Switch function. Using that function, a SQL CASE expression like this CASE WHEN condition1 THEN value1 WHEN condition2 THEN value2 ... END can be rewritten like this: Switch( condition1, value1, condition2, value2, ... ) A more specific, and probably more ...


1

If you link Student-->Course-->Module, you would avoiding having Module Z causing both Course A & B to show up for that student. Alternatively, you could slightly modify the current to have Student-->(Module & Course). If your Enrollment table includes all three identifiers, it would be trivial to determine if the student is enrolled in Module Z ...


1

Yes, by using linked tables. Here's the MySQL documentation https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html Add a User DSN from the ODBC Data Source Administrator, testing the link to your MySQL database to ensure you have the server, user name and password correct. In Access on the External Data tab ...



Only top voted, non community-wiki answers of a minimum length are eligible