close

Hi,

I have a database with a query like:

Select MonthJoined, GetUserName(UserID), Title, DoB
from UserTable

GetUserName is a user defined function that retrieves user name based on
UserID

I want to use this query in excel as data source
via pivot table --gt; Getdata --gt; MS Query

but MS Query could not execute GetUserName() function.

Is there any way around this?

I would prefer not to create another query in Excel - maintain all queries
in Access rather than Excel.

JB

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄