G
Guest
I have a query that calls a user defined function in Access.
e.g. GetCurrentBatchID (gets the current batch ID).
Query1
Select getcurrentbatchID(), items, destination FROM Tbl
I would like to create a pivot table from this query (Query1) in Excel but
Excel complains that the user defined function is not "defined".
JB
e.g. GetCurrentBatchID (gets the current batch ID).
Query1
Select getcurrentbatchID(), items, destination FROM Tbl
I would like to create a pivot table from this query (Query1) in Excel but
Excel complains that the user defined function is not "defined".
JB