DSUM problem

[duncan79]

Anyone know what expression i need to use in a DSUM condition cell i
order to get it to filter the results on a month basis??????

I've posted in misc, but no one seems to know.....

 

[Guest]

That is not too much information, but as you are using DSUM it is supposed
that you have a table to look at, and as you are looking for month figures,
it is supposed that you have a date/time field.
I would recommend creating a new column on the table, with the MONTH formula
(or a combination of MONTH and YEAR), and use that column in the DSUM
condition range (database functions don't take conditions from a single cell,
review the help if you have doubts on that)

Hope this helps,
Miguel.

 

[Guest]

What do you mean by that, I answered a similar post from you on May 18 with
clear instructions on how to use DSUM for January 2006?

http://tinyurl.com/qsk66


Regards,

Peo Sjoblom

 

[Guest]

Sorry, I didn't see the post before.

Peo is right, what is wrong with his answer?

Miguel.