DSUM problem

D

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.....
 
M

Miguel Zapico

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.
 
M

Miguel Zapico

Sorry, I didn't see the post before.

Peo is right, what is wrong with his answer?

Miguel.
 
Top