Avg column in dataset = label1.text?[RESOLVED]

[Nintendo_Wizard]

Hello. Is is possible to average a column in a dataset then display the results in a label? Just curious. can someone please share the code w/ me? Thanks

[Edneeis]

You can add a field to the query that is the average, I think you'll need to group them to do it, although you can group on something unique to make sure none are missed. Something like this:

SELECT ItemID, AVG(Modifier) AS AvgModifier
FROM ItemAttributeModInfo
GROUP BY ItemID