report by date

[billy_pit]

->Hi,
->My project is in MS Access 2002.
->In that I have one form which I am using to generate report by date.
->In that form I have two three fields StartDate,EndDate,ItemNo all
are of type Text.
->Now when I select StartDate and EndDate both of same Year then its
working properly.
->But if I select StartDate from Previous Year and Today's Date as
EndDate then it will simply show results of current year and only of
StartDate.
->Means if i enter StartDate=1/1/2007 and EndDate=02/19/2008 then it
will show all results of current year(1/1/2008-02/19/2008) and
results ,match date only 1/1/2007 but its not showing results between
1/1/2007 to 1/1/2008.

->I am using this query

->SELECT *
FROM PRODUCTION
WHERE ((PRODUCTION.ItemNo=Forms!Form1!ItemNo) And ((PRODUCTION.ODate)
Between Forms!Form1!StartDate And Forms!Form1!EndDate));

->I think my all fields are of type Text that's why this problem
occur.
->So I don't know what to do?
->Thanks for Help.