Dsum

[dominicgingras]

I have one table with customer and one table with "calls".
I want to show on the customer form all the tolal value($) of the call that that person made AND that are not paid(yes-no field).

I tried this on the form update event but its look like if my logic is wrong.. maybe its to late... its 3:30 downhere


Private Sub Form_Current()
Crédit = DSum("[Tarif]", "Appels", "[Forms]![Clients].[ClientID] and [Appels]![TransportPayé] = False&quot

End Sub

 

[pdupreez]

Just looking quickly at the code it looked fine, but I then realised that you had not equated the ClientId to anything, unless you wanted both of them equated to "FALSE", which did not seem logical.

Crédit = DSum("[Tarif]", "Appels", "[Forms]![Clients].[ClientID] and [Appels]![TransportPayé] = False&quot should perhaps read

Crédit = DSum("[Tarif]", "Appels", "[Forms]![Clients].[ClientID] = " & SelectedClientID & " and [Appels]![TransportPayé] = False&quot

where SelectedclientId is picked from a textbox or Combobox on your form somewhere.

Hope this explains it.

Regards


Pieter