Hi,
Why this Don't Work??
sqlstr = "SELECT * FROM users where [birthdata] >= " & birthdate1 & " and [BirthDate] <= " & birthdate2
Set rst = dbs.OpenRecordset(sqlstr)
This always return 0 records, where birthdate1 and birthdate2 are a textfield form!!
Thanks,
Mitch
Why this Don't Work??
sqlstr = "SELECT * FROM users where [birthdata] >= " & birthdate1 & " and [BirthDate] <= " & birthdate2
Set rst = dbs.OpenRecordset(sqlstr)
This always return 0 records, where birthdate1 and birthdate2 are a textfield form!!
Thanks,
Mitch