Thank y so much mister Long , due to you and your amazingly explained videos, I've gotten full marks for my access section of my CAT practical test in MATRIC and 96% overall for the entire test. All thanks to you. I hope that your videos will reach others and I will do my best to spread the word about you.
How do you do calculated fields with criteria? Like, I want a sum of all items in a field, but only if it's True/Yes? Same with grouping....I can't seem to apply criteria to fields that are grouped in a query.
Hello, I have a data have same date and I need to calculate the Stdev of for the whole day what is the formula to do that . the data is variables and measured approximately every 6 hours and 10 reading per once. i have sent you a screen shot from my data might it help you for answering my question.Thanks
Yes, you are probably referring to a value in your calculation that you may thiknk is a field in the table but it is not, either spelt incorrectly etc. Also try put [ ] around your field names especially if they have spaces in the name.@@D_Cousins3rd
Mr Long you deserve a special place in heaven
Thank y so much mister Long , due to you and your amazingly explained videos, I've gotten full marks for my access section of my CAT practical test in MATRIC and 96% overall for the entire test. All thanks to you. I hope that your videos will reach others and I will do my best to spread the word about you.
Thank you for the kind words. I'm so glad the videos have helped. Well done to you for putting in the hard work!
This man helping me to not fail matric
Glad the videos are helpful!
Did you pass because im writing tomorrow 😭
@Frostie-wm2bl Yo yo this just brought back memories😩
But yes I passed😂
I wished you were my professor. You are a life saver. Stay blessed
A lifesaver! Thank you Mr. Long
Thank you this was for my CSEC SBA and it helped alot
It's like Trevor Noah is teaching about Microsoft Access. Greetings from the US!
Awesome. Greetings from sunny South Africa
Thats why you the goat mr long❤❤❤❤❤❤❤❤❤❤.
Thank you mr long I literally love you ❤️
How do you do calculated fields with criteria? Like, I want a sum of all items in a field, but only if it's True/Yes? Same with grouping....I can't seem to apply criteria to fields that are grouped in a query.
Hi. Can you send me a screenshot of the data (sample) in the table and then the query design view. Send it to mister.long.it@gmail.com
Hello, I have a data have same date and I need to calculate the Stdev of for the whole day what is the formula to do that .
the data is variables and measured approximately every 6 hours and 10 reading per once. i have sent you a screen shot from my data might it help you for answering my question.Thanks
Sir when I try to go to the Datasheet view after having created the calculated field and it says 'Enter Parameter value' what should I enter there
It means that you type in the field wrong. Fields are case sensitive in MS Access
[NumPayments] and [Numpayments] is not the same thing
Always check your spelling when typing in the fields
Yes, you are probably referring to a value in your calculation that you may thiknk is a field in the table but it is not, either spelt incorrectly etc. Also try put [ ] around your field names especially if they have spaces in the name.@@D_Cousins3rd
@@D_Cousins3rd Ohh alright Thank you
@@MrLongITandCAT Alright Sir Thank you
Here 3 hours before the exam🕊️
Goat
Mine saying #Error😭