Linking criteria to query from combox box.

[Sianboy]

Hey All I need help on this query.

There is a combobox displaying different Car CC like "<661cc", "661cc - 1600cc" and ">3000cc". I aware I need to convert the non numeric text to numeric expressions before linking the criteria to the query itself. However, I have tried using multiple column box on this search criteria but could not do it as the access seemed to forbid signs like "<", ">" or "And" to the query itself.

Anyone who know how to do it I will appreciate your help. Thanks!

 

[John Big Booty]

Why not store the capacity in one field and the measurement in another field? This will make your life a whole lot easier.

Have a look at the attached, that might help you out.