Best way to call a Function ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access DCount function problem 0
Access Access Report Works on One Machine but not Another 3
Function in an ORDER BY statement 5
Usin VB in Sql Server 7
Lapsed Time when 1 date is null 2
Mid function used in query and report undefined 4
Undefined function in expression 4
Changing Function 1

Back
Top