Select query to gather results of other select queries

[PRTP]

Hi

I'm fairly new to Access. All I can do so far is tweak an existing query or setup the most basic select query.

I'm trying to setup what I thought would be a basic query but I'm puzzled.

There's various select queries containing useful and useless results. I want to create a select query that will pick out all the useful figures into a 1 row table that can then be pasted into Excel.

e.g Existing Select Query 1 returns 1 row showing Average Age, Average Price, Total rainfall
Existing Select Query 2 returns 1 row showing Average Weight, Average Salary, Total snowfall
Existing Select Query 3 returns *2* rows: It returns Distance from London, Hours daylight and population for Town A and Town B

I want a select query that returns 1 row showing (6 items):
Total rainfall, Total snowfall, Town A Distance from London, Town A Population, Town B Distance from London, Town B Population.


I've been able to handle getting Total rainfall and Total snowfall. But I cant figure out how to get Town A Distance from London, Town A Population, Town B Distance from London, Town B Population to appear in the same row of the same query results as Total rainfall, Total snowfall.

Is there a way?

Thanks

 

[plog]

Most likely. However we can't help you specifically without table information. Can you post your database?

 

[PRTP]

I can't unfortunately. And this was just a dummy/simplified scenario that I've described.

 

[JHB]

Have a look at functionally of a Crosstab query.
But as plog wrote, without table information we can't help you specifically.