Sum Macro (1 Viewer)

[Mitesh@Panchal]

Hi

I need macro which can make sum for special word. I need it for monthly expense schedule

colume A have all expense details for x head and colume b is value of expense

exa

a b
Tea 10
Tea 20
Tea 30
Tea 40

coffee 10
coffee 20
coffee 30
Coffee 40

I need macro for sum of expense

 

[AlexHedley]

You could use a DSUM.

http://www.599cd.com/tips/access/130809-dsum/?key=AlexForum

DSum ( expression, domain, [criteria] )

DSum("b", "tablename", "a=tea")