Access adding dsum to a form. Dsum inquiry about +/- values.

[HockeyDiablo]

Little out of my wheel house, would appreciate being pointed in the right direction on how to get the desired results.

I have a form where I need to add the value for credits and subtract the ones for billing. Consumed would be the amount of the (+)credit[static] or (-)Billing[dynamic]. The form reads from the following table.


Table: Tracking
*Company "companys name"
*Status "Credits(+),Billing(-)
*Consumed "Total for the Status transaction"

dsum seems to have me confused and will not get the results I would like #name and #error is all I get.


I have attempted the dsum in the expressions builder for control source.

Never really built anything in Access but needed a small scaled one so I have been doing some research, but this is the last step I can not seem to grasp.

Thanks guys

 

[Steven Schoors]

Adding a text field in the form header with this formula might work:
=DSum("[Consumed]";"Tracking";"[Status]='+'")-DSum("[Consumed]";"Tracking";"[Status]='-'")

good luck - steven

 

[HockeyDiablo]

Invalid syntax unfortunatley