"C. Bailey" wrote in message
news:Qtwri.70300$tB5.46959@edtnps90...
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

Hi C. Bailey,
I think I have the same problem : a very large database and some times I
want to extract a specific list.What I do is make a new table in the
Database , sometimes just manually if the list is not that long , sometimes
in VBA or in Excel.The table above would be a perfect example of what I
mean.Than call this new table : ProjectX.Than do a query which contains a
join (using the date in your example )between the database and the ProjectX
table where the ProjectX table is the feeder table.

hth
Gys