The records in my time field are formatted as hh:nn:ss. I want to query only records that fall on exact minutes (ex: 2:20:00). How do I query so that I only get results that end in (:00). thanks
Novice
Windows 7 64bit 
Access 2007
The records in my time field are formatted as hh:nn:ss. I want to query only records that fall on exact minutes (ex: 2:20:00). How do I query so that I only get results that end in (:00). thanks
VIP
Windows XP Access 2010 32bit
One way is to extract the seconds part from the time and set criteria as 0.
Is your time field a date/time datatype? Construct a field in query with expression: Format(fieldname,"s")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Query not showing all entries
Posting Permissions
Reply With Quote