Query Ran off a Pivot Table

[TBcontroller]

Hello,



I am no code expert and newer to access, so I am limited in SQL query creation. I am trying to run a query wit a pivot table that I need to have as my base and pull info off of other tables.

Is it possible to do this? or is there another way to create a table that is LINKED to the pivot table and updates?

Any suggestions on how to begin?

Br,
TB

[June7]

Don't really understand the question. Just because a table is in PivotTable view doesn't change the underlying table structure. Joining to a 'pivot table' is just joining to the actual table.

If you really mean you have a CROSSTAB query, that is different situation. Yes, CROSSTAB query can be used in another query.

[TBcontroller]

I apologize for not being clear. I have a pivot table ran off of 'Query 1' that totals specific Truck builds. I want to make 'Query 2' look up those values from the pivot table.

[June7]

Same applies to query. PivotTable view does not change the underlying source structure.

You want to look up totals?

Have you tried? What happens?

Have you explored CROSSTAB query to produce the pivot?

[TBcontroller]

Yeah, I have tried to add the pivot table into the relationship section. It has not allowed me. I am presuming since doing a pivot creates it as a form.

Correct, I have a query that has the builds of trucks and the parts in the build. I created a pivot to sum the costs per those builds of trucks. I am trying to pull those sums from the pivot back into a different query now.

Crosstab wouldn't work as the structure is different than a pivot.

[June7]

Well, I've never used pivot table/charts/form but I don't think you can 'pull' calculated results from them because there really is no object containing those results to pull from. For a form in pivot view, what textboxes would you reference?

Options may be:

1. I expect a CROSSTAB can be constructed to produce the desired output, just won't have the multi-row headers nor be interactive

2. VBA procedure with looping structure to write calculated data directly to a 'temp' table

3. export to Excel and do pivot there then link or import - it's my understanding that creating pivots is removed from Access 2016 and MS expects you do this export