Salamat sa iyong tutorial Pre. Laking tulong ito lalano may ginagawa ako ngayon na program gamit ang access para sa Asset and Inventory System namin dito. Andito ako ngayon sa Canada bro.
Hello, is it possible to conditionally format the graph? for example when sales are below 2000 the bar is red and if it's above it then it's green? thank you
Great ideas! I'd like to make a couple of suggestions. First, the sound quality. We can hear the hard consonants as your breath hits the microphone. And if you could increase the input volume that would be great, too. Second, I don't recommend the use of so many colors. Things tend to get too flashy. Other than that, good stuff!
Nice question. Any way, in row source, click the 3 dots ... to open the query builder. Change the format of your date into numerical value. Let's say 1,2,3... and sort it to ascending. I will create a video for this tonight.
Nice po Sir, andme ko po natutunan sa inyo. Pde po ba ung kunware may comparison ang dalawang year? Kunware current year at last year. Tpos may magdidisplay na variance base sa encode na data sa table?
I am creating an employee management system, and want to create a dashboard form where i want to show active employees , how many on vacations etc, how to achieve this?
Mr. Edcelle i have to make one correction in the syntax =Nz(DSum("FinalAmt","SalesQ","Month='" & [MTD] & ","),0). because its not working. Als the first one : =Nz(DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#"),0)
you have an error. it should be =Nz(DSum("FinalAmt", "SalesQ", "Month='" & [MTD] & "'"), 0). For the today's code is =DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#")
Salamat sa iyong tutorial Pre. Laking tulong ito lalano may ginagawa ako ngayon na program gamit ang access para sa Asset and Inventory System namin dito. Andito ako ngayon sa Canada bro.
Maraming salamat sa panonood bro.
Hello, is it possible to conditionally format the graph? for example when sales are below 2000 the bar is red and if it's above it then it's green? thank you
Thanks so much for the effects bro. I really appreciate
Welcome. Thanks for watching
Great ideas! I'd like to make a couple of suggestions. First, the sound quality. We can hear the hard consonants as your breath hits the microphone. And if you could increase the input volume that would be great, too. Second, I don't recommend the use of so many colors. Things tend to get too flashy. Other than that, good stuff!
Thank you so much for your suggestions. It's highly appreciated.
And also thank you for watching.
This is wonderful ❤️
Thanks for watching
Sir can it be assigned a permanent color category in the pie chart? Thanks
Which video did you create the report in?
Great and awesome video...I have been looking for such a tutorial.....
please can you share the file?
Thank you for an awesome tutorial!
How do I get the months in the Axis Category to filter into the correct order E.g. (Jan - Feb - March)?
Nice question.
Any way, in row source, click the 3 dots ... to open the query builder.
Change the format of your date into numerical value. Let's say 1,2,3...
and sort it to ascending.
I will create a video for this tonight.
Here's the link.
ua-cam.com/video/N8bmOBuqVuc/v-deo.html
Nice instruction, What I see is that the months in the chart are in some random order. How do you order them from left to right or from right to left?
Here's the video: ua-cam.com/video/N8bmOBuqVuc/v-deo.html
Good❤
Goood
Thanks
Nice po Sir, andme ko po natutunan sa inyo. Pde po ba ung kunware may comparison ang dalawang year? Kunware current year at last year. Tpos may magdidisplay na variance base sa encode na data sa table?
Pwede po. Instead na current year, last year yung ilagay sa criteria. Same concept pa rin.
Salamat pala sa panonood.
Do you have a tutorial to display images in a dashboard that will change like a slider?
Nice idea. On Timer Event Function.
I'll to create.
I am creating an employee management system, and want to create a dashboard form where i want to show active employees , how many on vacations etc, how to achieve this?
Just use the DCOUNT function.
Same process with dlookup and dsum.
Nice
Mr. Edcelle i have to make one correction in the syntax =Nz(DSum("FinalAmt","SalesQ","Month='" & [MTD] & ","),0). because its not working. Als the first one : =Nz(DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#"),0)
you have an error. it should be =Nz(DSum("FinalAmt", "SalesQ", "Month='" & [MTD] & "'"), 0). For the today's code is =DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#")
Hi po, kindly check kung ano mali,, error po eh
=Nz(DSum("GrossAmt","ExpSummary","Month='" & [MTD] & "'"),0)
Pwede mo e.share file mo mam para ma.check ko.
@@EdcelleJohnGulfan where to send po, and alsp pede mag enroll sayo para maenhance p alam ko
@@EdcelleJohnGulfan thank u hs
eduardogulfan@gmail.com
Hi can i have file access? Thanks
Good İdea
Thank you
Sir magkaano pagawa nang program?
Depende po sa project sir. For more details, you can contact me in fb messenger ED PEREZ MATUGAS GULFAN
Salamat sa tanong
please do a video on sale module
Yes sure. The POS side.
can i have the file please
Ang bilis masyado, hinde masundan....
Pasensya. Pause mo nalang if medyo mabilis. Next time hinaan ko nalang ng konti. Thanks for watching.