Automatic Make-Table Initiation

[Earl C Phillips]

I have a report that extracts test results of nutrition education and testing. This education is run to teach nutrition and strength training to the elderly and young students. After recording the test results and class attendance, a set of two queries extract that data, then a Make-Table query creates an intermediate table. The report is created from the table to show results, including improvement in test scores and such. I was under the impression that starting the report would initiate the Make Table query if the data had changed. It does not.

How do I make the intermediate make-table query run if the underlying data has changed (or not)? If I delete the contents of the intermediate table, the report is not be generated and errors out over field availability. I have tried various DoCmd methods without success. Help us feed the hungry and educate people on nutrition.

 

[Earl C Phillips]

Your response helped me get the report to work as originally intended. I created a DoCmd.OpenQuery in the Report_Open event for the Make-Table query. The reason for the intermediate table is because the report combines two different Crosstab results from the same Make-Table into one report.

Thank you for your help in tracking nutrition education for the indigent and elderly.