Recordset Indicies & Null Values

I'm using VBA & ADODB to maneuver through a recordset that contains a single record.

All variables are defined per Option explicit, and are all properly initiated.

When I run the SQL statement in SQL view of an Access Query, I get a single record with 7 fields. Each field contains the correct (non-null) value.

When I run the below code, I get message boxes that contain "*field name* = " -- the value is null.
Code: Dim rs as ADODB.Recordset Set rs = New ADODB.Recordset rs.Open sqlstr, conn, adOpenDynamic, adLockReadOnly If Not rs.EOF Then rs.MoveFirst For i = 0 To 6 MsgBox rs.Fields(i).Name & " = " & rs.Fields(i).Value Next i rs.close End IfOh, and the kicker is: this code worked yesterday.

So what gives? My connection must be OK, otherwise the query would be bombing at the .Open command. I'm obviously receiving results, because it's delivering message boxes. But where did my values fall out? Like I said, I'm receiving results when I run the SQL outside VBA...

<edit>

Just in case you're interested, here's my SQL. My table contains a Float for turnaroundTime, and the Level is restricted to Lvl1 ... Lvl7.
Code:SELECT [Lvl1Qry].[TheAvg] AS Lvl1Avg, [Lvl2Qry].[TheAvg] AS Lvl2Avg, [Lvl3Qry].[TheAvg] AS Lvl3Avg, [Lvl4Qry].[TheAvg] AS Lvl4Avg, [Lvl5Qry].[TheAvg] AS Lvl5Avg, [Lvl6Qry].[TheAvg] AS Lvl6Avg, [Lvl7Qry].[TheAvg] AS Lvl7AvgFROM (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl1*") AS Lvl1Qry, (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl2*") AS Lvl2Qry, (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl3*") AS Lvl3Qry, (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl4*") AS Lvl4Qry, (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl5*") AS Lvl5Qry, (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl6*") AS Lvl6Qry, (SELECT AVG([myTable].[turnaroundTime]) AS TheAvg FROM [myTable] WHERE [myTable].[Level] Like "Lvl7*") AS Lvl7Qry; </edit>