I am developing an application in asp.net and want to query from a table.\[code\]select userinfo.* from userinfo where userinfo.userid not in (select checkinout.userid from checkinout where checktime > #2012-10-03# and checkinout.checktype = 'O')\[/code\]I want to pass time as well in checktime condition. how can i do this?
Access datetime query
- Thread starter Bestow
- Start date