Running a make table on an external field

[Delboy14]

Crystal Reports 8.5, Access XP

Hi,
I have a problem that my database is growing so large that subsequently running reports on it is taking far too long. I was wondering if there was a way to run a make table query (In Access) usings an ID as a parameter, WHERE clause (which is passed from an external source eg Crystal Reports), this would allow me to run many subsequent queries on this smaller record set, and include data from this quickly into the report. Thanks in advance

 

[Delboy14]

sorry but to make it clearer the SQL would look like:

SELECT Consults.Index, Consults.PatientIndex, Consults.ConsultDate, Consults.PracticeID INTO tempConsult
FROM Consults
WHERE Consults.PracticeID=[IMPORTED ID NAME]
ORDER BY Consults.Index;