Thread: Pivot table populating via Access query

I've got a pivot table in Excel that needs to be fed from a table/query in Access. The problem is that a VBA function I wrote needs to be run before the recordset can be accessed. I can't see any way to have the pivot table run a macro or my Access function, and I can't figure a way in Access to have a query run a function and return a recordset to excel. Am I missing something? Is there a better way to approach this?

The function goes through a fairly complicated set of code to build an account table showing whether the balance has been paid in full. In order to do this, it it pulling from multiple tables. The account table is what excel is looking for. I can't use a make table to accomplish this, because of the detail in the function I wrote.

How can I solve this problem?

Thanks,

Terry