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
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
The iif function not working on mine please send me
Hello, kindly reach me at +254743238248 for assistance
fine explanatn. in the iif function you can end with, "" so that nothing is returned when you dont pick anything.
Thank you
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
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
Where is the last part of the queries
Reach out to me for the guidelines; 0743238248
'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
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
HOW CAN I CREAT A BOREHOLE CODE
My quiz is when calculating will you use commers after each word
How did you create those queries, that is the question
I created them from tables, you can contact me via +254743238248 for the guidelines
How did you created the queries
I created them from tables, you can contact me via +254743238248 for the guidelines
May I get the System flowchart
Check on my new upload
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
why am I getting Duplicates in my total amount paid by each client query ?
It's because of the relationships
What about documentation
I will upload a detailed guide on the same
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
what about the forms
Check on my channel, I have a video on the same
@@creativeminds4231 ok thanks
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
niceeeeee
Thank you
Help me on calculating downpayment fee, please
kindly reach me via this number +254743238248 so that I can guide you
Why doesn't total amount paid by client not include down payment and pump installation
cost
It should include them
Can I get the flowchart.
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
Si walai mniokolee na flowchart tafadhali
Will upload a detailed guide on the same
Can I get all the formulas for calculating the queries in written form
Yeah I can send you the pictures
Can I get flowcharts
Sure, I will post a tutorial on the same