Pbaldy,
Thanks for all of your assistance and I took your advice and did this
'Send information to TempReport_Table
DoCmd.SetWarnings False
DoCmd.OpenQuery "TrackingSystem3 Query"
DoCmd.SetWarnings True
Tell me what you think. Also if possible can i ask you a question about looping? I wont send you any information until you respond. And Again Thank You so much for all of your assistance.