Best way to call a Function ?

's Computer Specifications

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.

's Computer Specifications

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

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

"SL" <(E-Mail Removed)> wrote in message
news:4234E018-F5B7-4B04-8E69-(E-Mail Removed)...
>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.
>

's Computer Specifications

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.

"Alex Dybenko" wrote:

> 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
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
> "SL" <(E-Mail Removed)> wrote in message
> news:4234E018-F5B7-4B04-8E69-(E-Mail Removed)...
> >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.
> >
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Call javascript function without using any event call	cschang	Microsoft ADO .NET	3	1st Feb 2005 03:04 AM
Why does a call to a function in a dll take less time if you call it repeatedly?	Justin Galzic	Microsoft Dot NET Framework	5	23rd Feb 2004 06:09 PM
how do i call a function by using the function name as a string of characters	Keith G Hicks	Microsoft Access Form Coding	2	11th Feb 2004 05:19 AM
CommandBar function call w/o parens runs function 2-3 times	Mark Hammer	Microsoft Access Form Coding	0	1st Jan 2004 04:53 AM
How to call a function in a DLL with a function pointer parameter?	David Rose	Microsoft C# .NET	2	6th Aug 2003 07:52 PM