I'm trying to show upcoming events (today onwards) from my Access Database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tambesonal11
    New Member
    • Mar 2013
    • 3

    I'm trying to show upcoming events (today onwards) from my Access Database

    I'm trying to upcoming events (today onwards) from my Access Database with
    "event_time "


    Plz help
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    What have you tried?

    Comment

    • tambesonal11
      New Member
      • Mar 2013
      • 3

      #3
      In access table i have events some past events and some upcoming events.

      I want to show upcoming events

      Comment

      • r035198x
        MVP
        • Sep 2006
        • 13225

        #4
        Generally you would create a query that selects the data with a where clause that says where dateColumnName > Date()

        See example: http://www.techonthenet.com/access/f.../date/date.php

        Comment

        • tambesonal11
          New Member
          • Mar 2013
          • 3

          #5
          thank you so much
          :)

          Comment

          • sharmajv
            New Member
            • Apr 2013
            • 11

            #6
            If you are using Oracle Please use

            "Select DATECOLUMN FROM XXX TABLE WHERE DATECOLUMN > TRUNC(SYSDATE)"

            Comment

            Working...