I was trying to solve a info request problem for a department that is comfortable with Excel but not the ins and outs of Access. I came up with a workaround that allows them to run 1 make table query each month in the Access Database so that it is a local table and then all they have to do is...
The pivot is tied directly into the query.
I actually think it is probably a network permissions thing. The Database that contains the query is using a linked Data table from another users folder to pull the sales data. The problem is that neither of these folders are my network folder, I have...
I am trying to use an Access Query that is pulling from a local table and a linked table from another database to create an Excel Pivot table. I am not getting any data in my Pivot table. The Access query is actually a query built on a intermediate query that uses a table linked from another...