How to display all data in a range with non-numerical criteria (2)

[Sianboy]

Here another similar question,

The database will show all car's particulars as long its registered date matches the year inside the combo box of the form. For example, a car with registered date of 1999 will be displayed once the user choose 1999 in the combox box. The problem now is, what if the combo box got non-numerical values like "<1 year(s) old" or <10 years(s) old". How am I going to display cars with registration dates that fulfilled such criteria which is a range and yet, possess non-numerical value.

Need help asap and the solutions provided should be simplied as non-sql user here. Thanks!

 

[KenHigg]

ASAP? You must have gotten the forum mixed up with a pay-per-help site?

 

[Sianboy]

ASAP? You must have gotten the forum mixed up with a pay-per-help site?

I didnt mean this way, is a inquiry and hope those who know can help me.

 

[KenHigg]

Sorry, ASAP makes it sound like you want us to drop what we're doing to come to your aid -

And be thankful that you get any solutions, much less 'simplified' because you have no time to learn sql, whatever that meant.