create a totals column

[chris]

Hi all.
I'm having trouble creating a totals column in MS Graph.
Here's what I'm trying to do:
Using Access 97 to track the problems our equipment is
having. The problems are broken into categories:
HiFi, Mechanical, Video, Audio, Electronic, ect.

In Access reports I created a chart using the chart
wizard, created a standard bar chart which shows how many
of each problem there was in the current month.

So, this month there are 2 audio problems, 5 HiFi
problems, 6 Mechanical problems, and 1video problems.
Total of 12 problems. How do I create a totals column?

Chris

 

[Bill S]

Chris,

**Create a query that groups and counts your audio problems. Call it Query1:

SELECT Problems, Count([Problems]) AS NumOfProbs
FROM YourProblemsTable
GROUP BY Problems

--Result set:

Problems NumOfProbs
Audio Problems 2
HiFI 5

**Create another query that sums the total amount of problems. Call it Query2:

SELECT Sum([NumOfProbs]) AS TotalProbs
FROM Query1

--Result Set:

TotalProbs
7

**Create a third query with the previous two queries and including all three columns. Call it whatever you want and use this query to supply the data for your Chart:

SELECT Query1.Problems, Query1.NumOfProbs, Query2.TotalProbs
FROM Query1, Query2

--Result Set:

Problems NumOfProbs TotalProbs
Audio Problems 2 7
HiFI 5 7


This will give you a column with the total number of problems in every record along with a group and count of each problem.

Good luck!

Bill S

Hi all.
I'm having trouble creating a totals column in MS Graph.
Here's what I'm trying to do:
Using Access 97 to track the problems our equipment is
having. The problems are broken into categories:
HiFi, Mechanical, Video, Audio, Electronic, ect.

In Access reports I created a chart using the chart
wizard, created a standard bar chart which shows how many
of each problem there was in the current month.

So, this month there are 2 audio problems, 5 HiFi
problems, 6 Mechanical problems, and 1video problems.
Total of 12 problems. How do I create a totals column?

Chris