Help with date filter

[Guest]

I am using the following date filter in a column on my query. The problem I
have is that it is including dates i do not want to see. For example If
DStart2 = 1/3/07 and DEnd2 = 1/4/07 then it will return all records for
1/3/07 and 1/4/07 but will also return records for 1/30/07 and 1/31/07. Any
help?

 

[Guest]

Is your field a true DateTime datatype field or a text field? It seems like
the action is as if it is a text fields that you have loaded what appears to
be dates.
--
KARL DEWEY
Build a little - Test a little

I am using the following date filter in a column on my query. The problem I
have is that it is including dates i do not want to see. For example If
DStart2 = 1/3/07 and DEnd2 = 1/4/07 then it will return all records for
1/3/07 and 1/4/07 but will also return records for 1/30/07 and 1/31/07. Any
help?

([Forms]![MainForm]![DStart2]) And <([forms]![MainForm]![DEnd2]+1)