I have a subform whic has all the charges for my clients
At the bottom of the form I put a text box with this formula
=DSum("[charge]","Query1","[client data]=[client data]") so I can get a running sum of the charges
It works correctly but not in the currency format
Is there a way to have the format for currency
At the bottom of the form I put a text box with this formula
=DSum("[charge]","Query1","[client data]=[client data]") so I can get a running sum of the charges
It works correctly but not in the currency format
Is there a way to have the format for currency