I have an access table with a field "period" of Text data type. I have to retrieve records from the table between 2 periods using a select query. For retrieving records between periods 1 and 3, When i use "Between AND Operator" in query, then it returns all record which have a 1 in its period field. ie 1,11,12,13 etc.. If i give say 10 for starting period and 13 for ending period then it returns the record correctly. I figured out its the text data type causing the problem. I tried coverting the text data type to numbr using the following functions. "cint", "val", "clng" etc. But still am getting the same results. Can someone tell me whats going wrong?
Regards,
Charley
Regards,
Charley