Hi Phillip! Thanks for the great video. It has helped me with sub-queries in Access, what a great tool with Notepad ++! Did you say you have another video on sub-queries? Good to see you back in action again 🙂.
Thanks, is it possible to use calculated fields with additional tables joined while avoiding unupdateable errors. I want to show some calculated query result for display purpose in my form and i want to show these in the same row. The original fields will be updateable while these additionalcalculated fields are foe display only
I don't know about projectile motion. In general, Access can handle whatever expression you are able to enter in valid syntax. If you require more complex computations, you can write a VBA function and then use that function in the query to calculate the result.
Incredible execution on this video! Crystal clear; flawless. Thank you!
Good clear presentation and easy to follow. thank you
Excellent video understood everything Thank You 😊
Very clear instructions. Thank you :)
Easy to understand.. Thx master
THANKS YOU I WAS STRUGGLING FOR OVER AN HOUR 😭👍
Pretty clear and easier than I thought! Thank you sir!
Hi Phillip! Thanks for the great video. It has helped me with sub-queries in Access, what a great tool with Notepad ++! Did you say you have another video on sub-queries? Good to see you back in action again 🙂.
Dave, thank you! The video about subqueries is not complete yet, but it will be one of the next videos I'm going to release.
Thanks, is it possible to use calculated fields with additional tables joined while avoiding unupdateable errors. I want to show some calculated query result for display purpose in my form and i want to show these in the same row. The original fields will be updateable while these additionalcalculated fields are foe display only
how advance in terms of calculation can access handle? can it deal with formulas such as projectile motion?
I don't know about projectile motion.
In general, Access can handle whatever expression you are able to enter in valid syntax. If you require more complex computations, you can write a VBA function and then use that function in the query to calculate the result.