Criteria in the DSUM function

[thembela]

I got the follwoing DSUM FUCNTIOn: DSUM("APIMvmnt","HealthProduction","
[broker]=1000012946 ")

I wouldn't like to specify the broker number in the criteria part because it
only returns the values associated with this broker (1000012946),This formula
doesn't cater for other broker numbers i.e 10000003458,10000087977,
100000289722.How can i make it to cater for other brokers without specifying
a broker value in my criteria just like i've done.

Yo help would be greatly appreciated

 

[Remou]

Hi
If you wish to sum everything, skip the criteria altogether. If you wish to use different broker numbers, write:

Function MyDSUM(BrokerNo)
DSUM("APIMvmnt","HealthProduction","[broker]=" & BrokerNo & ")"
End Function