Access and VB.NET

0

My problem is that I define a query with parameters in MS ACCESS and I do not see it in the data sources in Visual Studio 2015 .

The query is:

SELECT *
FROM (
       SELECT * 
       FROM Ingresos,IngresosLin,PuenteContab 
       WHERE Ingresos.NroRecIng = IngresosLin.NroRecIng 
             And CtaDeuIng=Ctactb 
             And Ingresos.NroRecIng=?
     ) AS Rec, PuenteContab
WHERE MovIng = PuenteContab.Mvto;

Works correctly in Access . But I do not see it in Visual Studio because it is configured as a function and I do not have access to it for reports.

Any suggestions?

    
asked by Maximiliano Gil Toro 30.09.2016 в 17:30
source

1 answer

0

One possible solution is that you create the same query without parameters and filter it in the data source of the report.

I hope I helped you, Regards

    
answered by 23.09.2017 в 02:34