Hi I am using following lines to 1

[gerry03]

Hi

I am using following lines to obtain information from a table but when I run, it diasplays following error

data type mismatch in criteria expression

bill_date is date/time type field in bill_table. Help me to sort out the problem please.

In fact I want to retrieve data for a specified date or BETWEEN dates.


Set rsSrch = New ADODB.Recordset

SqlStr = "SELECT * FROM Bill_Table WHERE bill_date >= '" &
Format(Text4.Text, "dd-mm-yyyy&quot & "'"

rsSrch.Open SqlStr, ConnEdit, adOpenStatic, adLockOptimistic

 

[CCLINT]

1. If you are using a JET/ACCESS Mdb, then enclose the date in # signs instead of single quotes.

2. Format the date as mm-dd-yyyy

 

[gerry03]

Thanks CCLINT

I will try, and I hope this should be applicable.

One more thing in my last posts I asked how to edit an existing record but I couldn't get satisfied answer please be kind enough to solve that problem also.