Microsoft Access 2016 Tutorial: Calculated Fields in a Query in Access Databases

[@brysonshaw339]

You are the best teacher in the world. Thank you!

[@FH-ko2qg]

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.

[@chrisb8364]

This helped me with a big final project I am doing for my Accounting Auditing & Systems (AIS) class. THANK YOU SO MUCH!!

[@renellclarke-patterson8233]

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.

[@kamyaedmundkisenyi3410]

Thanks so much. I've needed this for the last 2 weeks

[@djluka120]

God bless your channel.

[@samuelgathiuwangari]

I never thought it was possible to do this in Access. Thanks a bunch.

[@danielsalumu2654]

Thank you so much for this video very very helpful

[@asalama1969]

you're just a wonderful, great teacher.thank you very much.

[@mashiyamahlengcobo1056]

This video is so helpful, and the explanation is crystal clear, Thank You ❤‍🔥

[@KaceliTechTraining]

Thank you for the feedback. Please press 'like' on the video if you can. It helps promote it to other users too.

[@MG555-g5v]

Thank you so much this helped with my IT SBA

[@keanubarendse7364]

Thanks ,This helps a lot ,see u guys after my Test

[@anthem4333]

You just saved my grades

[@thomasdixon7380]

This helped a lot for BTEC database. Thanks

[@universemath]

Nice explanations😃

[@StanslousSimwaka]

Thanks...it's well simplified

[@kuzugu671]

Thank You!

[@philipasedungaadjuah4174]

your videos are very useful. am taking online courses on the tutorials you release. keep it up

[@samoduke455]

Love this...

[@ashishtrivedi8253]

Great Help! Thx

[@charmainemeredith3030]

Thanks a million

[@chrisaguilar1410]

Great video. Thanks for the help!

[@SamuelWagema]

Excel presentation. Thank you Sali

[@kibetlucky5731]

thank you so much sir.

[@The_A_to_Z_Channel]

Thank you very much sir. You video will help me in doing my ICT assignment.

[@melissajones5269]

THANK YOU SIR!!!! awesome stuff

[@MesaySol]

Its helpful. Thanks!

[@Sai_Zz]

Thank you this helped me for my exam

[@ohenedarkoba8863]

Perfect. Loved it.

[@nicksonisiebea9852]

Thank you very much i got what i was looking for .

[@aceangler57]

Saved me! Thanks Sali!

[@jerinalex3713]

Thankyou so much Sir✌🏻

[@TheFaximana]

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

[@aramhasan6538]

Very Good .

[@mikey002]

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?

[@KaceliTechTraining]

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.

[@mikey002]

@@KaceliTechTraining Okay, thank you.

[@doborkulabb2643]

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?

[@hotdogbetlog3735]

Nice

[@ansariacupuncture9741]

Thank You Sir

[@deja-leethompson1211]

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.

[@doborkulabb2643]

I am trying to create an calculated Income statement

[@jermileemorrison7574]

percentage query plz

[@srimanikantapamidi4826]

How to add other currency symbols like pounds and rupees?

[@trevorcarnes2636]

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!

[@mkostovski]

Great job. Your Albanian accent is strong though :)

[@asuka_kun]

Thank you !

[@alžíďhħ]

Thank you! 😊