Hi,
Can this be done ?
I want to declare the variable in the SQL statement, and call it in the calculation where needed.. I tried it like this:
Doesn't work though 
SQL = "SELECT Verzekering.v_ID, Verzekering.maatschappij, Verzekering.soort," _ 
& "Verzekering.ProvisiePerc, Polissen.VerzId," _ 
& "([Polissen].[Kapitaal]*[Verzekering].[ProvisiePerc]) AS Prov" _ 
& "FROM Verzekering INNER JOIN Polissen ON Verzekering.v_ID = Polissen.VerzId;" 
 
'MsgBox Prov, vbOKCancel, "Provisie Berekening" ' for debugging
If Me.VerzId = 1 Then 
    Me.Provisie = Me.Kapitaal * (Prov)
Thanks !