One Function Two Outputs

[Guest]

Hello
Is it possible to have a function that returns two calculated values. If yes, how do I achieve this

TI
Anand

 

[Nikos Yannacopoulos]

Anand,

You can do this by using more arguments in a function, so you return
calculated values by means of the extra arguments, but those can only be
utilised in code, i.e. you can "read" the values in the extra arguments in
another piece of code that calls the function, but not in a query, form,
report etc.

HTH,
Nikos