Retrieve floating point data with an sql select statement

[Chris 83]

Hi

I'm quite new to using sql but I have a system working where I can read and write strings to an access database.

Now I want to retrieve a a float, from a field where another field in the same post corresponds to a specified float, with a select statement.

When using strings I wrote

SELECT column_name FROM [table_name] WHERE column2_name='value'

in my query.

But instead of getting the desired value I get an error message telling me that I have a

"Data type mismatch in criteria expression".

I think I understand why but does anybody know what I should have written instead?

[jcarmody]

Is the data type of column2_name String?  If it's not, I think the single-quotes you have around 'value' will cause that error.