I have DOB and Age in the table. In the query: Age column and Calculated Age column. How do I grab AUTOMATICALLY behind the scenes all the results from the Calculated Age column from the query and place on the Age column that is located in the table and also in the query. The only way I found so far was highlight and copy the Calculated Age column from the query and highlight the Age column either inside the query or in the table and paste all the results at once, and works. But I want to avoid this manual routine. Is there a macro or VBA to do this copy and paste these results to be stored in the table or another way. We want these results to be stored in the Age table. Would be so nice if the user when enters the DOB on the table, the Age field gets populated with the age. So I had to use the query to calculate the age of a necessity. Users were using manual hardcopy Age chart to input the Age in the Age field. So I created this automated feature to spare my hands and eyes strain, even with the copy and paste method, it's a breeze, in a blink of eyes, it input hundreds, thousands ages saving typing, time gain, less errors, and no hands and neck injury. I also tried to use query update, it says you can't update table with calculated field. That sucks.
