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?
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 😢😢
Great description
Good work with elaborate explanations.
Thank you
fine explanatn. in the iif function you can end with, "" so that nothing is returned when you dont pick anything.
Thank you
The iif function not working on mine please send me
Hello, kindly reach me at +254743238248 for assistance
'Your query does not iclude the specified expression 'Project ID' aspart of an aggregate fucntion' how can I fix this?
Reach out for help, 0743238248
hi you said u will post new videos on the last part of queries , the forms and also reports. wanted to consult when?
Hello, I am uploading them today, stay tuned
thank u for the info
@@creativeminds4231
My local authority and survey fees query is not running, it says "the expression you entered contains invalid syntax
Can you share it with me on this number; 0743238248
HOW CAN I CREAT A BOREHOLE CODE
How are you able to add the survey fees and the local authorities fees yngu imekataa
You have to create the queries first and make sure your relationships have referential integrity
Sikuelewi
@@RachelMathenge-dw8yn kindly check on my video on relationships
My queries are not running
14:55
My queries won't run the local authority fees and survey fees please help
Share the picture of your design view I see what's the problem
what about the diameter and length of the pipes because they are being charged?
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
why am I getting Duplicates in my total amount paid by each client query ?
It's because of the relationships
Hi bro.
My 'plumbing charges' query can't run. I did the same fomula with yours
Hello, check on the datatype of the depth field and change it to number
Where is the last part of the queries
Reach out to me for the guidelines; 0743238248
My quiz is when calculating will you use commers after each word
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?
Hello, sorry I ommited that but I should have included the fields
@@creativeminds4231 hello can you kindly check this query please ans update us on the total amount
Why doesn't total amount paid by client not include down payment and pump installation
cost
It should include them
niceeeeee
Thank you
May I get the System flowchart
Check on my new upload
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 😢😢
I used the borehole table and the plumbing price table
Make sure you have created the relationships before creating queries
Can I get the flowchart.
Help me on calculating downpayment fee, please
kindly reach me via this number +254743238248 so that I can guide you
Can I get all the formulas for calculating the queries in written form
Yeah I can send you the pictures
How did you create those queries, that is the question
I created them from tables, you can contact me via +254743238248 for the guidelines
What about documentation
I will upload a detailed guide on the same
Si walai mniokolee na flowchart tafadhali
Will upload a detailed guide on the same
what about the forms
Check on my channel, I have a video on the same
@@creativeminds4231 ok thanks
How did you created the queries
I created them from tables, you can contact me via +254743238248 for the guidelines
Can I get flowcharts
Sure, I will post a tutorial on the same