Dsum, multiple dates in the same month, not ordering right...

[mike02]

Here is my expression:

Net: FormatCurrency(DSum("[Cash]","AccountSummary","[ClientID]= " & [ClientID] & " And [MonthlyDate] <#" & [MonthlyDate] & "#"))



I have it working except for when the month has multiple dates in it. meaning.

02/01/2013......20
31/01/2013......10
and so on..

I starts the DSUM, in the wrong order. It should be flipped.

Thanks

[Dal Jeanis]

Is this consistent with all clients based upon your date order, or could this be a problem with the date order MM/DD/YYYY vs DD/MM/YYYY?

My eyes read Feb 1 vs Jan 31, and I wonder if the system might be too smart for its own good. Not likely, but first thing that popped into my head.

What is the underlying data that got those results?

[mike02]

the data it sums, is the expression value of another query. now access shows the dates are Jan 2 2013. and Jan 31 2013. I checked by running the query and seeing the value on the popup calendar.

Also, The MonthlyDate is sorted ascending. and it does have it in the correct order.

all dates inputed are in dd/mm/yyyy