Run queries on a query in Access

[sonikudi]

I have a query in access that outputs several part numbers with different shipment dates. I have same shipment date for different part types and same part types with different shipment dates. The query asks the user to enter the shipment date. I want to output all the same part types with their different shipment dates in temporary tables or a temporary location.

My ultimate goal is to graph this information by part type, (the query also outputs the precent rejected for the part type for e/ shipment date)..

Does anyone have an idea how to do this or somewhere where i can find some information??

Thanks!

 

[PWise]

Select [part numbers],[shipment dates],sum([precent rejected])as rejected
from Shipmenttable
group by [part numbers],[shipment dates]

 

[sonikudi]

thanks!