Recent content by pgordon

Thanks so much for trying to help me. I'm still struggling with this, I'm not getting it. I don't think I'm putting the statements in the right places. Do I create a calculated field and paste in the UPDATE statement above? If not, where do I put the UPDATE statement?

arnelgp, I'm sorry! I don't think I'm explaining it very well. I have a field [Ba_ppm], which is a text field, as it contains numbers and <0.05. I want to create a new field [Ba_ppm_CLEAN] which will be entirely numeric. I don't mind if the new field is in the existing table, or is...

Thanks for your reply. I'm not sure what I did wrong, but this is what I did: I created a new, numeric field in the table. then I created a query and in the criteria for [numeric field], I entered your expression, substituting in the correct field names. It returned the following...

Thanks Minty.

Hi folks, I have a table of lab results, and I need to either add a calculated field in the table or else generate a query which includes a calculated field. The lab results contain numbers (to 2 decimal places), and values which could not be accurately measured as they are below detection...

Hi all, I'm a very basic Access user, having used it for simple queries and forms, but I have no programming or code writing experience. I am working on a project that needs to store data in a database rather than something less secure than Excel (with which I have plenty of experience)...