Yes, k_date is a date field. I tried the ff.:

select * from kdata where k_date >= '09/01/1999'
select * from kdata where k_date >= '09/01/99'
select * from kdata where k_date >= {09/01/99}
select * from kdata where k_date >= {09/01/1999}
select * from kdata where k_date >= '{09/01/1999}'
select * from kdata where k_date >= {'09/01/1999'}

all this does not work.

Ramon Carlos

>
>Is Kdata a date field or a char field?
>
>If its a date field then try
>db_qry = db_qry & " where k_date >={" & Date_From & "}"
>
>Jeff