Getting an error with Dsum function in Subform (1 Viewer)

[sandya]

Hello friends, can anyone solve my issue

How to use Dsum Function? Am using below following Dsum functions but they are not working and shown an error result. I have attached the screenshot can you please replay how to use dsum in this case?

=Nz(DSum("[Liters]","[SRB_SubformQry]","[Category]=MILK"),0)
=Nz(DSum("[Liters]","[SRB_SubformQry]","[Category]='MILK'"),0)
=Nz(DSum("[Liters]","[SRB_SubformQry]","[Category]<>MILK"),0)

Thanks,
Sandhya.

 

[plog]

In your criteria argument you are doing numerical comparison, you need to do text comparison. that means adding single quotes around the text value you are comparing it to:

"[Category]=MILK"

Should be:

"[Category]='MILK'"

 

[sandya]

Yes, its working... But it's taken only rounded numbers... decimals are did't not count.. i need to count both of rounded numbers & in decimals digits also...

 

[sandya]

Thank you so much... its resolved