Need help with Query

[Sianboy]

Hey I got a query problem here and hope you all can help me.
I doing a school project and non-sql user here therefore the solutions provided should be as simple as possible.

Here the situation. In my database, I got a field called "Transmission" and the records inside are either "Auto" or "Manual". If I want to query for "Auto", I simply type this into the criteria box itself and vice versa. However, what if I want to show "Auto" and "Manual" if the user click on "Any" in the combo box I created in the form, what should I do it? As the "Any" is not in the field of "Transmission in the first place

A quick reply is appreciated as approaching deadline for my project. Thanks!

 

[michaelak117]

Could they just click both Auto and Transmission instead of any and you can include both in the criteria.

 

[Sianboy]

Could they just click both Auto and Transmission instead of any and you can include both in the criteria.

Can only click on "Any", "Auto" and "Transmission" these 3 only. In which once "Any" is selected, all cars will be displayed. Can mutli column combo box solved this problem? But I not sure how 2 create one.