1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Option Compare Database
Option Explicit
Private Sub Report_Load()
'Ici on teste si le OpenArgs est = 0 ou est null
'= 0 veut dire que tu as sélectionné TOUTES dans la liste déroulante des années
'Est null veut dire que tu as ouvert l'état sans passer par le formulaire
If Me.OpenArgs = 0 Or IsNull(Me.OpenArgs) Then
Me.txtSale = Nz(DSum("[Amount Sale]", "Project"), 0)
Me.txtSaleCAD = Nz(DSum("[Total in CAD]", "Invoicing Customers"), 0)
Me.txtBought = Nz(DSum("[Amount bought]", "Project"), 0)
Me.txtBoughtCAD = Nz(DSum("[Total CAD]", "Invoicing suppliers"), 0)
'Ici tu as sélectionné une année dans la liste déroulante
Else
Me.txtSale = Nz(DSum("[Amount Sale]", "Project", "Year([Delivery Date])=" & Me.OpenArgs), 0)
Me.txtSaleCAD = Nz(DSum("[Total in CAD]", "Invoicing Customers", "Year([Date F#])=" & Me.OpenArgs), 0)
Me.txtBought = Nz(DSum("[Amount bought]", "Project", "Year([Delivery Date])=" & Me.OpenArgs))
Me.txtBoughtCAD = Nz(DSum("[Total CAD]", "Invoicing suppliers", "Year([Date Inv#])=" & Me.OpenArgs), 0)
End If
End Sub |
Partager