help with query

[daraptor]

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......

[technobard]

I'm not 100% sure what you're asking. If you're using the QBE (Query by Example) screen, you literally just type in the code you're talking about. You have to include any columns you want to see in your output on the QBE form. If you're talking about SQL, that's a different story. Try creating a query using the wizard and then go into design view.

[defiantphantom]

H there daraptor,

I know ireplied to you very late
As to my understanding this is the sql statement you are looking for :

SELECT Airport_name FROM Airport_codes WHERE Airport_code = 'cmh'

Just replace chm with the txtbox name.


Hope that helps!