Mike Wolfe

Step 10. Repeat steps 8 & 9 until all tests pass

Step 9. Execute the test query in SQL Server

Step 8. Alter the scalar function to address failures

Step 7. Execute the test query in SQL Server to verify it fails

Step 6. Build a test query in SQL Server to return failing tests

Step 5. Create a dummy scalar function in SQL Server

Step 4. Use the results of your Access query to populate the test table

Step 3. Create a temporary test table in SQL Server

Step 2. Build a "test table population query" in Microsoft Access

Step 1. Identify or create test data in Microsoft Access