DSUM with date criteria from form

[krutoigoga]

Hello people.
Need help with a dsum code and date criteria.

The following code is used to display the "sum" of a field from a table.

=DSum("[Front]","Tracking","[DATES] Between #" & [Forms]![Search]![Text0] & "# And #" & [Forms]![Search]![Text2] & "#")

It shows the sum .. as requested, but it seems to ignore the date criteria (entered in text0 and text2). So if the sum of the field is 20 for the past 3 months, 5 of them in July - I search between July 1 and July 25th >> the result is 20, not 5. Make sense?

Table name: Tracking
Column (field) name: Front
Date Field name: Dates
Form name (used to enter dates): Search

PLEASE HELP!
Thanks.

[pbaldy]

How are you entering the date? If you're using a non-US date format, it will interpret

1/7/10

as January 7, not July 1.

http://support.microsoft.com/default...b;en-us;210069
http://www.mvps.org/access/datetime/date0005.htm

[krutoigoga]

How are you entering the date? If you're using a non-US date format, it will interpret

1/7/10

as January 7, not July 1.

http://support.microsoft.com/default...b;en-us;210069
http://www.mvps.org/access/datetime/date0005.htm

I am using 28/07/2010 (dd/mm/yyyy) a.e. the format for the date is set to "Medium Date" in the form. I require admin access to make changes in the regional settings (control panel).
From what I understood the format has to be mm/dd/yyyy?
I removed the Medium Date format from the form and the table. I tried search by the dates in mm/dd/yyyy, mm dd, mm dd yy, mm-dd-yy formats and the report still does not show the proper numbers.
Any ideas?

[pbaldy]

Did you try either of the methods in the links I posted? I've used the second in applications for UK clients with no problems.

[krutoigoga]

Did you try either of the methods in the links I posted? I've used the second in applications for UK clients with no problems.

Could not try the first link as I do not have admin access and I just don;t know where to add the code provided in the 2nd link.
I'm jusing VB code (provided by access forums) for the commnad button but thats as far as my limited knowledge goes.

Private Sub Command4_Click()
On Error GoTo Err_Command4_Click
    Dim stDocName As String
    stDocName = "Tracking Report"
    DoCmd.OpenReport stDocName, acPreview
Exit_Command4_Click:
    Exit Sub
Err_Command4_Click:
    MsgBox Err.Description
    Resume Exit_Command4_Click
    
End Sub