SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Selecting records in the future

    I currently have this query:

    Code:
    SELECT tblFlights.FlightNo,
    tblFlights.To,
    tblFlights.From,
    tblFlights.DepTime,
    tblFlights.ArrTime,
    tblFlights.Fare,
    tblCustomerFlights.CustomerID,
    tblCustomerFlights.Date
    FROM tblFlights
    INNER JOIN tblCustomerFlights
    ON tblFlights.FlightNo=tblCustomerFlights.FlightNo;
    What I want to do is add a WHERE clause so that it will only select records where the tblCustomerFlights.Date are in the future.

    This is being done in Microsoft Access by the way.

    Thanks in advance

    -Sam
    Sam Hastings

  2. #2
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Never mind, found out how:

    Added: WHERE tblCustomerFlights.Date > Date()

    to the end and it worked
    Sam Hastings


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •