Dear Experts

Table1 has three fields as
date d(8)
time c(8)
amount n(2)

and data in table is as
---date--------time---amount
05-10-07---15:35:55----50
05-10-07---20:35:55----65
06-10-07---05:35:55----70
06-10-07---07:35:55----10
06-10-07---12:35:55----40

I want to brows data with following time codition
From previous date 20:00:00 to Today 08:00:00

Suppose today is 06-10-07 then these recourds must brows

05-10-07---20:35:55----65
06-10-07---05:35:55----70
06-10-07---07:35:55----10



Please help