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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top