Append data in an Access Pivot Table to a Table (or requery on it) (1 Viewer)

Append data in an Access Pivot Table to a Table (or requery on it) in Access

Hey everyone,

Is there a way to append a pivot table to a table or possibly make a query based on a pivot table? I need to get a count of Part Numbers and I need the average price for all these parts. Additionally I want to ignore a count of less than 3. Is this possible?

Also I am having trouble filtering on the count in the pivot table... haha, so I was gonna Query on it later on.

If there's VBA code for this maybe, if you provide a sample I can tailor it. Thanks!

Thanks in advance everyone!:banghead:

Couple things:

1. You don't store calculated data, so you wouldn't send this data to a table, you would simply make query to generate the average. Then reference that query when you need to use the data elsewhere.

2. I don't see how a pivot table factors into this. Average per product is a pretty straight forward query:

I was thinking about this the wrong way. I appreciate your help! I did as you said and filtered using the Query.