I import tables from three different tills which I combine via a UNION query to make one huge file from which I then query and generate Invoices. The system works without a hitch except the UNION query (queries actually, their are two of them) take 35 seconds to run on my 1.6Ghz Athlon (yes, they are that big!). The problem is that each time I produce an invoice (Report) these UNION queries run. Since the tables are imported the data doesn't change during a session, I only really need these UNION queries to run once per session, and save that result to a table or something, to which all other queries, subqueries etc can refer. This would really speed things up. My question is, can it be done?