Recent content by wajans

Query1 SELECT DISTINCTROW sum(oce.TargetCount) AS TargetCount, oce.DivisionID, oce.CategoryID FROM tblEstimations AS oce GROUP BY oce.DivisionID, oce.CategoryID; Query2: SELECT ocs.CategoryID, u.DivisionID, sum(ocs.TotalCount) AS TotalCount FROM tblSubmissions AS ocs, tblPerson AS p, tblUnit AS...

How to execute queries dynamically so that the results of first query are the source for second query because in my case I have to pass divisionid dynamically to get submissions count and target count for categories and units in a particular division

Finally I am able to get the required results. Thanks a lot for helping and guiding me to correct direction. Instead of applying round circles I am just doing conditional formatting and changing the fields background color as red, yellow and green respectively in the grid based on the...

I need to display percentage of total submission count for each category for each division with respect to the total target count for each category for each division as shown in the attached screenshot. The attached screenshot contains the final output to be displayed with percentage and round...

That worked like a charm, Thanks a lot. I am getting below data in a table as required, However I wanted to show red colored circle instead of "red" text on a form or report. Could you please help me in getting that. Also is it possible to show percentage of submission count with the color on a...

Thanks for helping CJ_London. I am trying to use one of the below 2 queries. If I use any of the below queries, its opening window to enter parameter value for q.CategoryID or query1.CategoryID as shown in the attachment. select sum(ocs.Count) as TotalCount, q.CategoryID, q.DivisionID from...

Queries I wrote to get the final cross tab results are as below: query1(output in query1.png attached) SELECT DISTINCTROW sum(count) AS Target, sum(Red) AS RedCount, sum(Yellow) AS YellowCount, sum(Green) AS GreenCount, DivisionID, CategoryID FROM tblEstimations GROUP BY DivisionID, CategoryID...

forgot to add category table screenshot. Please find it here

Its a very long story :-) Let me explain you the scenario. I have a table tblEstimations(estimation.png), admin will be adding target count for each category, each unit, and each division. Estimation table has divisionid(linked to division(division.png) table), categoryid(linked with...

Thanks for your reply CJ_London. I used first in crosstab query and I am getting below alert box: Multi-level Group By clause is not allowed in a subquery.

Hello Everybody, How to make a column as column header and another column as row header in access. I have attached sample.png. I wanted to take Divisions as Column header and Categories as row headers and color as the data. Below is the sample output that I need: Catogery Division1...