How about:
SELECT * FROM tblAbc WHERE DTOS(trans_date) => '20061121' AND DTOS(trans_date) <= '20061127'
You query Date field and compare it with string, not allowed :o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.