How Can I Create A temp Table for Charts and Graphs

[Sly600rr]

Hello, I've been tring to do this for a long time, and have never been able to figure it out. I'm using an example from the database samples section of this forum.

http://www.access-programmers.co.uk/forums/showthread.php?t=99353


I was able to use the filter to make a report.

Dim stDocName As String
stDocName = "rptdata"
DoCmd.OpenReport stDocName, acPreview, WhereCondition:=BuildFilter


But I'm trying to used the filter to build a tempory table so I can make graphs and charts from it as well..

Please somebody help me!!

 

[John Big Booty]

This DB might help