Search results

Thanks for your time, I am using Querry. and using below conditions where a.keydoccheck = 18 and a.CheckedAsOf >= '4/02/2010' and format(timevalue([a.starttime3]), "Short Time") > "05:30") (where keydoccheck, checkedasof and stattime3 are filed name of particular table.) your formula...

yes it is linked sqL server table

using Access 2007 and getting results from SQL server

Thanks for your quick responce but still i am confused. I want the result with is = or > 5:30. i've tried below formula after your answer and format(timevalue([a.starttime3]), "hh:mm") > "05:30" and getting below error timevalue is not a recognized built-in fuction name

Thanks for looking into this. I am using MS access I've tried below constraint --and timevalue (hh:mm, [a.projectdone]) = 5:30 and getting below error incorrect syntax near hh:

hello, I want the datepart result in hh:mm:ss (excluding date) Please see below example Person Project Done a 04/01/2010 04:45:00 b 03/29/2010 04:55:00 c 02/28/2010 05:05:00 d 02/25/2010 05:31:00 I want to result > 5:30:00 I'd used below query...