Percentages

[Drew]

Does anyone know how to formulate percentages within a
group by query?

 

[Michel Walsh]

Hi,


SELECT ClientID, SUM(Amount) / ( SELECT SUM(Amount) FROM tableName)
FROM tableName
FROUP BY ClientID



Hoping it may help,
Vanderghast, Access MVP