Selecting records in the future

[SJH]

I currently have this query:

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

[SJH]

Never mind, found out how:

Added: WHERE tblCustomerFlights.Date > Date()

to the end and it worked