Uzima Bora Borehole drilling system Overview on Queries.

This is a detailed overview on the required queries required for the 2024 Computer studies Kcse project. Kindly feel free to contact me via [phone] if you have any inquiries.

[@francismutisya264]

Good work with elaborate explanations.

[@creativeminds4231]

Thank you

[@FaithGatwiri-eb6hr]

Great description

[@jaredmigeta5618]

fine explanatn. in the iif function you can end with, "" so that nothing is returned when you dont pick anything.

[@creativeminds4231]

Thank you

[@ivymacharia3672]

HOW CAN I CREAT A BOREHOLE CODE

[@sweatyopponent]

'Your query does not iclude the specified expression 'Project ID' aspart of an aggregate fucntion' how can I fix this?

[@creativeminds4231]

Reach out for help, 0743238248

[@ErickOginda]

My quiz is when calculating will you use commers after each word

[@messowalter8369]

My queries are not running
14:55

[@SofyLidz]

why am I getting Duplicates in my total amount paid by each client query ?

[@creativeminds4231]

It's because of the relationships

[@user-yf6vb3rm9f]

Where is the last part of the queries

[@creativeminds4231]

Reach out to me for the guidelines; 0743238248

[@abubakarjumah4771]

Hi bro.
My 'plumbing charges' query can't run. I did the same fomula with yours

[@creativeminds4231]

Hello, check on the datatype of the depth field and change it to number

[@moseswaita893]

Can I get the flowchart.

[@sujalvarsani8541]

My local authority and survey fees query is not running, it says "the expression you entered contains invalid syntax

[@creativeminds4231]

Can you share it with me on this number; 0743238248

[@Bigman697]

My queries won't run the local authority fees and survey fees please help

[@creativeminds4231]

Share the picture of your design view I see what's the problem

[@prudeyiyadi1557]

The iif function not working on mine please send me

[@creativeminds4231]

Hello, kindly reach me at [phone] for assistance

[@meshacklimo4855]

what about the diameter and length of the pipes because they are being charged?

[@creativeminds4231]

You'll specify your own values under the diameter and length field which you'll then use in the queries to find the plumbing charges

[@WANDAGIREJOICE]

Help me on calculating downpayment fee, please

[@creativeminds4231]

kindly reach me via this number [phone] so that I can guide you

[@muzzammilhaffiz8490]

hi you said u will post new videos on the last part of queries , the forms and also reports. wanted to consult when?

[@creativeminds4231]

Hello, I am uploading them today, stay tuned

[@muzzammilhaffiz8490]

thank u for the info
@@creativeminds4231

[@user-tz6fd2xk7x]

niceeeeee

[@creativeminds4231]

Thank you

[@beatriceomath5437]

Why doesn't total amount paid by client not include down payment and pump installation
cost

[@creativeminds4231]

It should include them

[@MustafaJeylan]

Hi bro,, in the total amount paid you only added survey and local authority fees+plumbing charges but you did not include the drilling charges and the pump installation charges, may i ask why?

[@creativeminds4231]

Hello, sorry I ommited that but I should have included the fields

[@BonfaceMutie-xi6bi]

@@creativeminds4231 hello can you kindly check this query please ans update us on the total amount

[@whitneybundi765]

How did you create those queries, that is the question

[@creativeminds4231]

I created them from tables, you can contact me via [phone] for the guidelines

[@JacklineOmwoyo]

Hi bro the cost of plumbing charges like which table did you use kindly cause mine is showing a pop up that the specified depth could refer to more than one table in the from clause of your sql statement please kindly help i don't understand why 😢😢

[@creativeminds4231]

I used the borehole table and the plumbing price table

[@creativeminds4231]

Make sure you have created the relationships before creating queries

[@BenterAwino]

May I get the System flowchart

[@creativeminds4231]

Check on my new upload

[@suleimanngome6978]

How did you created the queries

[@creativeminds4231]

I created them from tables, you can contact me via [phone] for the guidelines

[@RachelMathenge-dw8yn]

How are you able to add the survey fees and the local authorities fees yngu imekataa

[@creativeminds4231]

You have to create the queries first and make sure your relationships have referential integrity

[@RachelMathenge-dw8yn]

Sikuelewi

[@creativeminds4231]

@@RachelMathenge-dw8yn kindly check on my video on relationships

[@ayubjoseph-du1ng]

Can I get all the formulas for calculating the queries in written form

[@creativeminds4231]

Yeah I can send you the pictures

[@immaculatemakokha4084]

What about documentation

[@creativeminds4231]

I will upload a detailed guide on the same

[@fredrickkalevu]

Can I get flowcharts

[@creativeminds4231]

Sure, I will post a tutorial on the same

[@RichardNyapeni]

Si walai mniokolee na flowchart tafadhali

[@creativeminds4231]

Will upload a detailed guide on the same

[@user-dm3zm8se9i]

what about the forms

[@creativeminds4231]

Check on my channel, I have a video on the same

[@user-dm3zm8se9i]

@@creativeminds4231 ok thanks