Query 911

[danerikk]

Hi guys!

I need help with a query for a school assignment. I need to create a query to get data from two tables, which I will copy into a Excell spreadsheet. The format of the data needs to be exactly like that of the spreadsheet, and this is where Im stuck...

The access tables:

Booking
======
ClientID
TourID
Language

Tours
=====
TourID
Course Name
++

The format I need to use is; TourID, Course Name, "French", "German", "Italian", "Spanish".

The languages all derive from the Language field in the Booking table, and what I need to do is to compress all records into one record by the TourID and then calculate the number of bookings for a language course.

I managed to calculate the language courses bookings using count function. But the data is still per booking record, not compressed into one TourID.

It probably sounds impossible, at least for me. Im not a newbie or anything to access or excell, but this one's tricky, cause I did not create the access database myself...

Anyone with some insight and help to solve this puzzle is greatly apreciated!


Cheers,

Dan

 

[namliam]

It far from impossible, which is why it is an assignment offcourse.

Now without solving your 'homework' for you, I would look into the Crosstab functionality if I were you...