Total volume

[Pietro]

Hi,
I've the following query:

SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

I need to add a new coulmn "Volume" to know thw total volume of the cases
where type =[forms]![ragents]![type2] so that i may select a type from the
combobox on the form to know the number of cases and percentage of every
agent...

 

[KARL DEWEY]

I need to add a new coulmn "Volume" to know thw total volume of the cases
What is the formula to use for volume?

Here is your WHERE statement ---
SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
WHERE [Assistq2].[Type] =[Forms]![Ragents]![Type2]
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

 

[Pietro]

Thank you KARL for your answer...
I don't have a problem in the WHERE statment,I need to know the percentage
of each [Type] compared to total numbers of types...
Consequently i need to know total numbers of types

What is the formula to use for volume?

Here is your WHERE statement ---
SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
WHERE [Assistq2].[Type] =[Forms]![Ragents]![Type2]
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

--
KARL DEWEY
Build a little - Test a little

Hi,
I've the following query:

SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

I need to add a new coulmn "Volume" to know thw total volume of the cases
where type =[forms]![ragents]![type2] so that i may select a type from the
combobox on the form to know the number of cases and percentage of every
agent...

 

[KARL DEWEY]

What has that to do with "Volume"?
--
KARL DEWEY
Build a little - Test a little

Thank you KARL for your answer...
I don't have a problem in the WHERE statment,I need to know the percentage
of each [Type] compared to total numbers of types...
Consequently i need to know total numbers of types

I need to add a new coulmn "Volume" to know thw total volume of the cases

What is the formula to use for volume?

Here is your WHERE statement ---
SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
WHERE [Assistq2].[Type] =[Forms]![Ragents]![Type2]
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

--
KARL DEWEY
Build a little - Test a little

Hi,
I've the following query:

SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

I need to add a new coulmn "Volume" to know thw total volume of the cases
where type =[forms]![ragents]![type2] so that i may select a type from the
combobox on the form to know the number of cases and percentage of every
agent...

 

[KARL DEWEY]

I need to know the percentage of each [Type]
-----------
Which is it percent Type or Agent or both?

--
KARL DEWEY
Build a little - Test a little

Thank you KARL for your answer...
I don't have a problem in the WHERE statment,I need to know the percentage
of each [Type] compared to total numbers of types...
Consequently i need to know total numbers of types

I need to add a new coulmn "Volume" to know thw total volume of the cases

What is the formula to use for volume?

Here is your WHERE statement ---
SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
WHERE [Assistq2].[Type] =[Forms]![Ragents]![Type2]
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

--
KARL DEWEY
Build a little - Test a little

Hi,
I've the following query:

SELECT Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type,
Count(Assistq2.Code) AS Cases
FROM Assistq2
GROUP BY Assistq2.ID, Assistq2.[Agent Name], Assistq2.Language, Assistq2.Type
ORDER BY Count(Assistq2.Code) DESC;

I need to add a new coulmn "Volume" to know thw total volume of the cases
where type =[forms]![ragents]![type2] so that i may select a type from the
combobox on the form to know the number of cases and percentage of every
agent...