1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Option Compare Database
Option Explicit
Public p_strSqlWhere As String, p_strIn As String
Public Const p_constStrSqlSelect As String = "SELECT ID, [Invoice leasing company ID], [Invoice addressee name], " _
& "[Contract status code], [Contract ID], [Invoice due date], [Customer name], " _
& "[Customer ID], [Invoice number], [Invoice invoicing date], [Invoice gross balance (signed)], " _
& "[Invoice addressee ID], Filtrage " _
& "FROM tbl_openamounts "
Public Const p_constStrSqlSelectOutlook As String = "SELECT ID, [Invoice leasing company ID], [Invoice addressee name], " _
& "[Contract ID], [Invoice due date], " _
& "[Invoice number], [Invoice invoicing date], [Invoice gross balance (signed)], " _
& "FROM tbl_openamounts "
Public Const p_constStrSqlOrder As String = " ORDER BY [Invoice addressee name], [Contract status code], [Contract ID], [Invoice due date]"
Public Const p_constStrSqlOrderOutlook As String = " ORDER BY [Invoice addressee name], [Contract ID], [Invoice due date]" |
Partager