the correct writing..

[lena]

rstImage.Open "SELECT * FROM Image WHERE SystemNo = ' " & SystemNoUnit & " ' " AND time >= '" + Ttime + " ' ", ConCX, adOpenForwardOnly





can anyone Help me .. how is the correct writing .
any suggestions?

Thanks

[June7]

Assuming SystemNoUnit is text type field and Time is a date/time type field, try:

"SELECT * FROM Image WHERE SystemNo = '" & SystemNoUnit & "' AND time >= #" & Ttime & "#", ConCX, adOpenForwardOnly

[lena]

Thanks June7 for your attention.... but i still get error

Ttime = 2013-11-28 10:01:34

the error --> '10' ????????

[June7]

Is Time field a text or date/time type?

Is Ttime an unbound textbox or a variable? The Ttime value is not in standard date/time format - should be: mm/dd/yyyy hh:mm:ss

Don't understand the error - what is the full error message?