RonaldRoenhorst
Gebruiker
- Lid geworden
- 25 dec 2008
- Berichten
- 188
Code:
string OleDb = " SELECT P1.Jaar, P1.Week, FORMAT(P1.Datum, 'dd.MM.yyyy') as Datum, P1.Meter, Previous " +
" (SELECT MAX(Meter) FROM Table1 AS P2 " +
"WHERE P2.Jaar = P1.Jaar AND P2.[Meter] < P1.[Meter]) AS Previous , P1.[Meter]-[Previous] AS Verbruik " +
" " +
"FROM Table1 AS P1";
Hoe krijg ik de Datum van Table1 as P2 in de datagrid ?