Access query and VB .NET problem

[BryanTyler]

Hi!

I have trouble accessing data from a query. I am using VS.NET 2003 against ACcess 2000.

The acces query returns two fields and many rows. The query works fine in access. How should i set it up in vb .net to retrieve all the data from the query ? I tried using a datareader but i always get the message that 'Microsoft Jet cannot find table or query...'. ( Yes the query name is correctly spelled in the code ) ;-)

Any help would be greatly appreciated. It is the first time i use these tools togheter and am currently quite confused.

Thanks

[mendhak]

Post your code so we can see what you're doing.

[BryanTyler]

I found the problem. The query i was using was built for a report. So it was calling many other queries. Some among them had formatting commands. It ran fine with the report but when executed from a oledb command object these commands ( like Format$ and others ) were causing problems.

Thanks anyway.

Bryan

[mendhak]

Yeah... that was going to be my next response.