Thread: help with query
View Single Post
Old 12-13-2006, 07:00 AM   #1 (permalink)
daraptor
Recruit
 
Join Date: Dec 2006
Posts: 14
daraptor is on a distinguished road
help with query

hey guyz...am a newbie to sql....
i got this table in MS access which has got all the airport codes.........
the name of the table is Airport_codes...
the column names in the table are.....Airport_code, Airport_name, State, Country......so my problem is what would be the query to get any airport code.....for example
when i type cmh in the search box it should bring up port columbus intl airport .....
like this i should be able to bring up any airport code jss by typin the code in the search box....i hope u got my point....i know this is a dumb question...but am a newbie...am quite confused...hope someone will help me out with this.....thanx guyz......
daraptor is offline   Reply With Quote