I can run the below Stored Procedure fine with a pass-through query. However, I want to be able to change the parameter of EntityFilterFullNameWithChildren to something other than "Jones". I'd presume I need to create a function and run DoCmd.RunSQL xxx, where I am able to set xxx to below. Can someone create the entire function that would allow me to run a pass-through query along with a stored procedure with the required connection syntax?
Code:sp_report Actuals show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActual_Title, Text, Label, AmountActualCost, AmountActualRevenue, AmountDifferenceActual parameters DateMacro = 'All', EntityFilterFullNameWithChildren = 'Jones', SummarizeColumnsBy = 'TotalOnly'