Search results

Thank you Shallo9. Your code worked. But I made one change in my table. I renamed all my field names from "100","220",.....to "a100","a220",...... I think Access has problem with field names starting with numbers. After the change it worked. Is it possible to achieve the same result without...

Thank you. I will try it on my data and let you know. This might solve my problem.

This is the expression I have used as you suggested. I have used this expression in control source as I am not using programming for my project. =DAvg([Stepno].[Value],"[k data]") Aim is to compute average for field name as "100" in table "K data". Depending on the text box "Stepno"...

Thank you for responding. If user enters "diameter" in text box then press Buton in the form, following should happen. 1. look in the table for the field name as "Diameter" 2. Do avg, min, max and SD on that field 3. Output those values to a form which displays Avg, Min, Max and SD of that...

hi, I have a table with many fields. I want user to select field based on text box value. Eg: if user enters "Diameter", the output table should contain only "Diameter" field. Can some one help me regarding this. My end goal is to do Avg, Min, Max and SD on that pirticular field what...