 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / March 2006Query Help
I have a a table in access that a column has the data :2006-03-03 00:45:09.000, it is a time stamp that just keeps changing. My question is how would I query just on the hour. So I could query on 00:45 and 00:46. Thanks Chad >I have a a table in access that a column has the data :2006-03-03 >00:45:09.000, it is a time stamp that just keeps changing. My question [quoted text clipped - 3 lines] >Thanks >Chad What's the datatype of this field? Is it in a native Access table or a linked table of some sort? Access Date/Time values do not have millisecond precision (only to the nearest second) nor do they have colons, so I'm guessing it's Text. Try using a calculated field: TheHour: Hour(CDate(Mid([timestamp], 2, 19))) Mid will extract the date/time portion; CDate will convert this to a date/time; Hour will extract just the hour portion thereof. John W. Vinson[MVP] Do this in Query?? Thanks Chad >Do this in Query?? > >Thanks >Chad Yes. Put the calculated field expression in a vacant Field cell in the query grid. John W. Vinson[MVP] Do this in Query?? Thanks Chad I might add it is a text field that is labeled CreationTimeStamp |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.