This video was so useful. I had been stuck on how to perform the basic steps. Kaceli walked us through query building step by step. This was of immense use. Thank you.
Thank you so much for this. This helped me with a project for my class . I appreciate the easy to follow step by step guide through the process and the detailed explanations. You have the goft of teaching, thanks for sharing it with us.
Very helpful explanations - many thanks! I there a possibility to take fields (values) from other tables too into these calculations? I would be very grateful for an answer
I have a problem sir. In my case, i was given a commission rate and in order to get the commission amount in $, I needed to multiply the commission rate by the total sales which is a field in my database. The commission rate isn't a field. I decided to do it manually like what you did and every time I do it, it only shows "Enter Parameter Value" in a box after I click run. Any thoughts sir?
If the commission rate is always the same, you could enter it as part of the calculation. The best however is to have a separate field for the rate in the one of the tables and then multiply the sale with the commission rate. Obviously, the tables need to be linked in order to do that.
Hi. If I have a drop down menu with let say the opportunity to choose from expenses and revenue and by choosing one of them (before entering the amount) how do I calculate the + and - amount from a certain sub total?
No matter what I do, whether or not i save it, run it, re-create it i can't get the expression categories automatically. The only difference between mine and the one in this video is that there is no criteria. Please Help.
Hello, great video! I created a query that contains 2 summed fields and 2 count fields, then a few more fields that divides these to get percentages. When I run a report based on that query, the fields where I calculated the percentages populate, but the fields where I used the sum and count function do not. The header and all is there but, the cells are blank. Any thoughts? Thank you!
This video was so useful. I had been stuck on how to perform the basic steps. Kaceli walked us through query building step by step. This was of immense use. Thank you.
You are the best teacher in the world. Thank you!
This helped me with a big final project I am doing for my Accounting Auditing & Systems (AIS) class. THANK YOU SO MUCH!!
Thank you so much for this. This helped me with a project for my class . I appreciate the easy to follow step by step guide through the process and the detailed explanations. You have the goft of teaching, thanks for sharing it with us.
I never thought it was possible to do this in Access. Thanks a bunch.
Thanks so much. I've needed this for the last 2 weeks
This video is so helpful, and the explanation is crystal clear, Thank You ❤🔥
Thank you for the feedback. Please press 'like' on the video if you can. It helps promote it to other users too.
God bless your channel.
Thank you so much this helped with my IT SBA
your videos are very useful. am taking online courses on the tutorials you release. keep it up
This helped a lot for BTEC database. Thanks
Thanks ,This helps a lot ,see u guys after my Test
You just saved my grades
Very helpful explanations - many thanks! I there a possibility to take fields (values) from other tables too into these calculations? I would be very grateful for an answer
Thank you so much for this video very very helpful
I have a problem sir. In my case, i was given a commission rate and in order to get the commission amount in $, I needed to multiply the commission rate by the total sales which is a field in my database. The commission rate isn't a field. I decided to do it manually like what you did and every time I do it, it only shows "Enter Parameter Value" in a box after I click run. Any thoughts sir?
If the commission rate is always the same, you could enter it as part of the calculation. The best however is to have a separate field for the rate in the one of the tables and then multiply the sale with the commission rate. Obviously, the tables need to be linked in order to do that.
@@KaceliTechTraining Okay, thank you.
you're just a wonderful, great teacher.thank you very much.
Hi. If I have a drop down menu with let say the opportunity to choose from expenses and revenue and by choosing one of them (before entering the amount) how do I calculate the + and - amount from a certain sub total?
Nice explanations😃
Thanks...it's well simplified
Thank you this helped me for my exam
Thank you very much sir. You video will help me in doing my ICT assignment.
Great video. Thanks for the help!
THANK YOU SIR!!!! awesome stuff
No matter what I do, whether or not i save it, run it, re-create it i can't get the expression categories automatically. The only difference between mine and the one in this video is that there is no criteria. Please Help.
Great Help! Thx
Thank You!
Love this...
Excel presentation. Thank you Sali
thank you so much sir.
Thanks a million
Its helpful. Thanks!
Thank you very much i got what i was looking for .
Thankyou so much Sir✌🏻
How to add other currency symbols like pounds and rupees?
I am trying to create an calculated Income statement
Perfect. Loved it.
Saved me! Thanks Sali!
percentage query plz
Hello, great video! I created a query that contains 2 summed fields and 2 count fields, then a few more fields that divides these to get percentages. When I run a report based on that query, the fields where I calculated the percentages populate, but the fields where I used the sum and count function do not. The header and all is there but, the cells are blank. Any thoughts? Thank you!
Very Good .
Nice
Thank You Sir
Great job. Your Albanian accent is strong though :)
Thank you !
Thank you! 😊