locked
MS Access hour selection problem........ RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1249732592 posted

    I want to select a query like

    select * from tablename where date between 09:00 PM AND Next day Morning 6:00 AM

    what is query for particular syntax????

    Monday, August 30, 2010 4:51 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1153490049 posted

    select * from table where pubtime between #2008-1-5# and #2008-5-18#
     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, August 31, 2010 2:19 AM