How to "merge" queries

[Marino]

Hi!

I have a database with two tables: one is about users of our transport
(tblUsers), and the other one is
with information about a used transportation (tblTransports).

Now I have to make a report that will retrive me the information how many
transports did some organization have during one month, represented daily.
Information about what organization does the user belongs to is stored in
table tblUsers. Beside that i have to retrive the information based on types
of rides: Going to doctor, going to church,...

It should look something like this

Date Org A Org B Org C
Total Doctor Church

01. 01. 2007. 1 2 0
3 2 1
15. 01. 2007. 0 5 4
9 8 10
....

It's about free rides to handicaped persons....


Thank you very much in advance

 

[Guest]

Create a query linking the two tables and save it. Next go to Queries on the
Objects Bar and select New. From that list pick the Crosstab Query Wizard and
base the crosstab on the query that you just saved. It may take a few tries
as crosstabs aren't all that easy to get one mind around; however, it should
be what you need.

Eventually you'll want to learn about the column headings when working with
crosstabs. Here's a very good resourse on crosstabs from Allen Browne:
http://allenbrowne.com/ser-67.html