Query in Access

Question

I having problems previewing existing data in the server explorer : So created a query in access, the query works fine in access, but when I go to server explorer under the view folder and try to retrieve the existing data thats in the mdb , it saids null for each column or no data is in the table which is false. Do anyone know why is this.  Whats weird is for any other table or view in the database, I can retrieve the data.

I think the program cannot understand the query , its really weird. the query im using is below.


SELECT maxoftestid, maxoftestnames, timestamps, msn, min(pass) AS testpass
FROM PassOrFailByEtag
WHERE ecode Like '[123456789ABCD]*'
GROUP BY maxoftestnames, timestamps, maxoftestid, msn
ORDER BY timestamps;