Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Martin Dempsey
- Order by date
-
Querying date and time
I do. I formatted the field as "HHNN" then converted it as a number field. this way I got 9:00:00 PM as 2100. I was then able to filter all records greater then 2100. Works perfectly.- Martin Dempsey
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Querying date and time
all, thanks for the guidance, I found a solution. turned the time portion into a number and querying as >2100 Thanks!- Martin Dempsey
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Querying date and time
thanks, that would explain the struggle. I can query a different date field just for the date, I need to figure out how to query the specific time need then. Tried using the format method to format the date field to show just the long time, but can't seem to query that either. I added a field...- Martin Dempsey
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Querying date and time
hi, I'm struggling with a query that I think should be easy, hoping to get some help. I have a table with a date/time field. I need to query this field for a specific date and all records <= 9aM AND all records >= 9PM. When I use the following criteria it works, >=#03/26/2018# and...- Martin Dempsey
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
