Query question - SQL syntax and joining multiple tables/queries

Hi all,

I'm trying to output a result set from some data as follows:

I have raw data with the following columns

Date,
Country,
System,
ID,
Revenue,
RecCount,
RPM,
Duration

I create 4 crosstab queries that give me

Country, System, ID as row headings
Date as the column heading
and one of Revenue, RecCount, RPM or duration as the value.

I only choose two dates so the columns are

Country, System, ID, Date1, Date2

for all the queries.

I then want to join then all up so I have

Country, System, ID, Revenue Date1, Revenue Date2, RecCount Date1,
RecCount Date2, RPM Date1, RPM Date2, Duration Date1, Duration, Date2

I'm struggling to make the final query work... any thoughts?

Thanks,

Rob.