Search results

Hi Team, I would like to ask help for the Chart color format. Trying to copy here the screenshot of the forms output but it doesn't allow me. Attached is the database, kindly open the form and you will see the chart output. Is there a way to manually change the color of each column and to...

Hi XPS35, Thank you for your suggestion and the draft. Yes for the graphs I will just do separate queries. Solved

Can someone please suggest

Hi All, With the help of Accessworld Team, my dabatase is progressing well. I have attached the latest draft and would like to ask your suggestion on the next step. Based on the Database Query, its filtering the Customers, Product A etc...and the result form is as below. Since there are 5...

Solved. Thank you arnelgp

thanks Il do that in my actual file.. hope you can assist me with the attached file that i've sent

Hi, Have to filter the date because it will be a yearly report. In this case from 01/09/22 - 01/09/23 Sept 01 not Jan 9

hi, just want to confirm if you revised something on the attachment, it looks exactly the same as the version 1.3

Hi XPS35, Hi All, XPS35 has provided the solution to my previous query and really works. Single average value per Cust_ I revised the query due to additional requirements by filtering the class"M" from ">#01/09/2022# And <#01/9/2023#" But the form display several values of Cust_A, Cust_B...

Thanks XPS35, really appriate your help. As suggested, Il raise different post thread to my second query. Thanks all..

Thank you for the suggestion, maybe this is the reason why no one responses to my second query:) Anyway, in my initial email I mentioned that I have 2 queries but thanks for the suggestion, Il make a new query.

Hi XPS35, My next query is.. how to it possible to create a chart like in excel based on the generated values as below from the database that you sent:

Hi All, Thanks for all your suggestions, I'm not expert to this field and just need simple formula like the database sent by XPS35. I can already use this database.

Hi All, The database is attached is my initial message, can someone have a look and apply the possible solutions on my query

hi xps35 The dashboard is a single form and the other forms are in Continuous Forms format. I guessed its not possible to copy the average formula in Continuous Forms to Single form type. And a chart is required based on the values from the dashboard

Hi, Ok Im not aware of it, as im not expert to access. About the TempVars, this is completely new to me and I have to research how to apply this in this project the im working

Hi, Tried your suggestion and I saw its working when other forms are open. However, the value should display regardless other forms are open or closed. This dashboard will be the primary files that my boss will open

Hi AccessWorld Team, From the Database1 file that I'm woriking, I created a form called "Dashboard" and added 3 text boxes. The value of these 3 text boxes should be taken from the value of the text box "Average" from the forms namely "FCust_A", "FCust_A", "FCust_A" which are different forms...

Hi Arnelgp, It works, the best. Query 1, 2 and 3 works as expected based on the database you provided. Its just an addition, I'm trying to add 2 more line after the table but its giving an error. Attached is the sample of the line that I want to add

Really appreciated your help Anelgp, I will check and test all the information you have added, not now but later. Have some urgent things to go to.... Thank you and have a nice day