access my field

[iccsi]

I have a query liek following:

SELECT MyTable.ID, Avg(MyTable1.[AHT]) AS Result, MyTable1.Login_ID
FROM MyTbale1
Where MyTable.ID = MyTable1.Login_ID
GROUP BY MyTable.ID, MyTbale1.Login_ID;

I am unable to access field using VBA for the field Result.

It gives me ID for fields(0) and give me Login_ID for fields(1) and
does not recognize fields("Result").

Are there any way to access group query fields?


Your help is great appreciated,

 

[Douglas J. Steele]

That's invalid SQL, so I suspect you typed it into your question.

Copy-and-paste the actual code you're using, please.