sum if...

L

lis

i have a table with two fields:
Field A - date field in dd/mm/yyyy format.
Field B - value

I'd like to display on a form the sum of Field B for the current month and
for the year to date. For example the form should read:

February Sales : $25,000
2009 Sales : $153,000

thanks
lis
 
Top