Best way to call a Function ?

S

SL

I have a function that calculates time, with the function result displayed on
a report.
The report is bound to a Query and this all works fine.

What I want to know is, is it better to run the function from the report or
the SQL query?

Thanks for your advice.
 
A

Alex Dybenko

if you use function in every row - the I would put function in a query, if
function result same for all rows - then I would put it directly into report
 
O

Ofer

To add to the prev answer you got, if you want to use the query in other
reports or forms without the function, then call the function in the report.
 
Top