I am fairly new at SQL and VBA.

I am working with a very large database. For simplicity sake, let's assume
the database is for a rental company and it records the number of kilometers
driven on different dates and for different cars.

I have created a query that can successfully pull the data for one car
between given dates. But what I would like to do is pull data for many cars
(not all cars) for different dates and organize them in a table like this:


Car 1 Car 3 Car 4
1/1/2007 50 105 104
1/2/2007 34 15 30
1/3/2007 5 157 26


I could take the query I have, and create a VBA loop to query for every car
I want. Is this the most efficient way to do this? It seems "wasteful".

Thank you,
Chris