Query Help

[pianoboy11]

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.

is there anything wrong with query, the query works fine in access, but when i try to preview data in c# , It says the table is empty which is false


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

[RuralGuy]

So could this be a C# issue?

[pianoboy11]

I may have a better ideal

I have a crosstab , and the crosstab have data that occurs

How to write a query to pull 3 column from the crosstab into a table.

that way I can just call the query in code. I did a select from the crosstab which works, but its not a query I can call to update the table everytime.


example, view the excel sheet or attachment