Great Video! Maybe you can assist me further. I have a query that I want a specific item displayed, in a column. THen I need the dame FIELD added with a different but specific time displayed. How can you make this happen since it reads left to right and stops at the first criteria? Help!
Dear Sir....Thank for video tutorial. there is a question ... the update query is updating all the record of Past sales or purchase ... if we want only next record at sales point or purchase is it possible ?
i am updating an old Access booklet that asks 'to change all size values of single to coach' Update query works off values and this table under size has text. i have updated my workbook to use Ctrl F instead. Would you say this is correct?
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 at once saving typing, time gain, less errors, and no hands and neck injury. I tried to make query update table, but it says that table can't be updated if data is from calculated field in the query (Age calculation). So it sucks.
dear sirs nice and clear video but would you pls send me video clarify how make the update query one time within period because it is unbelievable to make this action always plss clarify me how make query work one time then stop then work again in other time automatically
Hi Kirt, thank you for this nice and clear video. Now, if i may, this example is only about number update query. Would it be possible to have from text type, date type, yes/no type? My own issue is i am trying to updates hours. I got dates at GMT when i am at GMT-5. I can make successfully the extra field, GMT-5 field, but i can't succeed in updating the original dates. Do you have an existing video? Or what would be the "update" function? DateAdd("h",-5,"GMT") is not working for me. Thanks in advance for your help. Fabien.
Can I just say you are kind of like the Bob Ross of Access for some reason that come in to my head but any ways your vids are alot of help.
Thank you 😊
Great Video! Maybe you can assist me further. I have a query that I want a specific item displayed, in a column. THen I need the dame FIELD added with a different but specific time displayed. How can you make this happen since it reads left to right and stops at the first criteria? Help!
Dear Sir....Thank for video tutorial. there is a question ... the update query is updating all the record of Past sales or purchase ... if we want only next record at sales point or purchase is it possible ?
i am updating an old Access booklet that asks 'to change all size values of single to coach' Update query works off values and this table under size has text. i have updated my workbook to use Ctrl F instead. Would you say this is correct?
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 at once saving typing, time gain, less errors, and no hands and neck injury. I tried to make query update table, but it says that table can't be updated if data is from calculated field in the query (Age calculation). So it sucks.
dear sirs nice and clear video but would you pls send me video clarify how make the update query one time within period because it is unbelievable to make this action always plss clarify me how make query work one time then stop then work again in other time automatically
Hi Kirt, thank you for this nice and clear video. Now, if i may, this example is only about number update query. Would it be possible to have from text type, date type, yes/no type? My own issue is i am trying to updates hours. I got dates at GMT when i am at GMT-5. I can make successfully the extra field, GMT-5 field, but i can't succeed in updating the original dates. Do you have an existing video? Or what would be the "update" function? DateAdd("h",-5,"GMT") is not working for me.
Thanks in advance for your help. Fabien.