dsum count arror 1

[ajking]

I have a table "tbMain_Rec" which contains, amongst others, two fields [Call_Vol] and [txtDate]
if I use a basic dsum function eg.
Vol = DSum("[call_vol]", "tbmain_rec") the resulting 'Vol'= 75 which agrees with a manual count of the contents of the [call_vol]column
but if I use the following date criteria which covers the full range of the table "tbMain_Rec":
Vol = DSum"[Call_Vol]", "tbmain_Rec", "[txtDate] between #01/10/2006# And #24/11/2006#"). The result = 40
Can anyone explain what is causing this anomaly?

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[Remou]

You must use US or ANSI format dates:

mm/dd/yyyy or yyyy/mm/dd

Or suitable variations of the above.

 

[ajking]

Hi Remou
Many thanks! I will rejig my coding.

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980