Can a function return more than one value ? 1

[ZABADAK]

I have a report that prints monthly percentages and then a quarterly percentage.
I have a function that calculates the monthly percentages. I'd like this function to pass back not only the percentage but also the dividend and divisor for the calculation so that I can use these to form the quarterly percentage. Is this possible or is there a more elegant solution?
Each figure in the calculation is obtained by running a complex SQL query so I don't want to run each one more than once.
Thanks for any advice.

 

[sfreeman]

see:

http://allenbrowne.com/ser-16.html

Sam_F
"90% of the problem is asking the right question.

 

[dbsquared]

in your function you can send the other variables byRef.
Ex:
Private Function Example(Byref Divisor as long, byRef Dividend as long)
'code to find divisor and dividend
example=dividend/Divisor

end function

To go where no programmer has gone before.

 

[traingamer]

You might try creating those additional variables when the report opens, then increment them each time the monthly ones are incremented, then calculate your quarterly result in the footer.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[SkipVought]

Hi,

Put each of the values in an array element and return the array.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[Ed2020]

Alternatively declare a new variable type:

Public Type Test
Val1 as Variant
Val2 as Variant
End Type

Public Funtion MyFunc() as Test
'...some code here

MyFunc.Val1=55
MyFunc.Val2=66

End Function

Ed Metcalfe.

Please do not feed the trolls.....

 

[SkipVought]

Ed,

I like that. Yet another way to skin a cat!

==> *

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}