Conversion Query?

[natonstan]

I'll try and describe this as clearly as I can, basically I have a table that contains a range of Electronic components, as well as their weight and size, basically I have a query that lists items that are over a certain height and weight, now my only problem is that this table isn't in a single format, some parts will say '3 feet' some will say 3' and some 3 feet, I'm trying to make a macro that would convert it into a format and then display it if it's over a specific weight/height.. as of right now i'm stumped so I would be very grateful if anyone can help.

[June7]

Make it a number field instead of text and only numbers can be entered and this issue would be avoided.

Are you saying those apostrophes might actually be entered into the data as '3 feet'? Any other characters that might precede the number?

Try something like:

SELECT * FROM table WHERE Val(Replace([fieldname],"'","")) > 3;