Prev: Formatting in columns
Next: Combining forename and surname fields in report
From: Arvi Laanemets on 16 Apr 2010 01:06
Hi

Is subject possible?

From SQL Server, I can call the function as
Select * From dbo.udf_MyFunction(Parameter1, Parameter2, ...)

From Access front-end, I want to call this function, and use the result
table as data source for report.
My quess is, that I have to use a pass-through query for this.

Has someone any experience with this?
Thanks in advance!

Arvi Laanemets

From: Sylvain Lafontaine on 16 Apr 2010 02:13
Yes, you need to use a pass-through query using a Select query like the one
you have shown us.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Arvi Laanemets" <garbage(a)hot.ee> wrote in message
news:uDEqSKS3KHA.4028(a)TK2MSFTNGP05.phx.gbl...
> Hi
>
> Is subject possible?
>
> From SQL Server, I can call the function as
> Select * From dbo.udf_MyFunction(Parameter1, Parameter2, ...)
>
> From Access front-end, I want to call this function, and use the result
> table as data source for report.
> My quess is, that I have to use a pass-through query for this.
>
> Has someone any experience with this?
> Thanks in advance!
>
> Arvi Laanemets


 | 
Pages: 1
Prev: Formatting in columns
Next: Combining forename and surname fields in report