I downloaded the file from Post #13.....it still has the look up fields.......
Oops, I forgot to answer "is it possible to change the column headers in a query??
Yes, you can and it is easy.
You have a query "Query_Test" - the SQL is
Code:
SELECT airline_dir.*
FROM airline_dir
WHERE Airport & Airline NOT IN (SELECT Airport & Airline FROM received_files_table WHERE Format(Received_Date, "mmmyy") = [enter MMMYY]);
It is not recommended to use the "*" (all fields) so I'm going to change the query to
Code:
SELECT airline_dir.Airport, airline_dir.Airline
FROM airline_dir
WHERE ((([Airport] & [Airline]) Not In (SELECT Airport & Airline FROM received_files_table WHERE Format(Received_Date, "mmmyy") = [enter MMMYY])));
I'm going to change the query column names to "MyAirport" and MyAirline"
The SQL looks like
Code:
SELECT airline_dir.Airport AS MyAirline, airline_dir.Airline AS MyAirline
FROM airline_dir
WHERE ((([Airport] & [Airline]) Not In (SELECT Airport & Airline FROM received_files_table WHERE Format(Received_Date, "mmmyy") = [enter MMMYY])));
In the query design grid:
(Note the colon)
MyAireline:Airline