Search results

No Problem Bob, here are the details I have 2 parameters that could be observed multiple times for an item on a given day. I then want to take all the observations and make a fancy average out of it. Ex: Item Par1 Par2 A 10 11 A 10.5 12 A 9 14 B 4 5 B 6 7 Solution: A 10.3 B 5 It will...

Well.. the "aggregated" come from the error message that I'm getting when i try to pass a array to my function: "You tried to execute a query that does not include the specified exception 'MyAvg(Px)' as part of an aggregate function" Public Function MyAvg(Px() As Double) As Double ... End...

Hi I’m trying to create my own custom aggregated function: Ex: SELECT Obs_Date, Item, MyAvg(Px) FROM Sales GROUP BY Obs_Date, Item; I know how to create a vba function that will deal with single record… but somehow, I can’t figure how to create one that will deal with...