Dear Experts,
I need help! I want to change below count formula into Dsum formula. Actually i want to get the total keeping the same criteria.
=DCount("*","QAFAM2","[HC EXP YEAR] = 2019 AND [HEALTH CARD RENEWAL]>0")
Dear Experts,
I need help! I want to change below count formula into Dsum formula. Actually i want to get the total keeping the same criteria.
=DCount("*","QAFAM2","[HC EXP YEAR] = 2019 AND [HEALTH CARD RENEWAL]>0")
Try:
=DSum("*","QAFAM2","[HC EXP YEAR] = 2019 AND [HEALTH CARD RENEWAL]>0")
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Hi Bob,
I tried above formula, i gives me an error. Below is the screen shots.
What is the name of the field that you want to total
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
I want to total of below field name
HEALTH CARD RENEWAL
Try:
=DSum("[HEALTH CARD RENEWAL]","QAFAM2","[HC EXP YEAR] = 2019 AND [HEALTH CARD RENEWAL]>0")
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Hi Bob,
Excellent ! Its working now
Good. Glad to be of help.
BTW It is not considered to be best practice to have spaces or "special characters" (Google: "access special characters list") in the names of any objects in Access.
"HealthCardRenewal" would be better than "HEALTH CARD RENEWAL"
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Hi Bob,
Copied that. I will make the changes . Thank you for your suggestion