external Data Query 1

[robcarr]

Hi,

I have a spreadsheet with 4 different queries on, in different columns, for ease of use I would like to have all the query results in 1 column, is it possible to either

1 combine all queries into 1 query, they have similar info, and each type peice of info would be in the same column

2 make the queries refresh below each other depending ont he data found.

hope this makes sense.

Rob.


Hope this is of use, Rob.

 

[robcarr]

sorted it myslef, sorry

Hope this is of use, Rob.

 

[SkipVought]

Rob,

Did you make a UNION query?

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[robcarr]

no, not that complicated just stuck the queries under each other, and the data auto adjusts row lengths.

works for me.

Rob.

Hope this is of use, Rob.

 

[SkipVought]

as long as the number of rows does not change, I suppose.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[robcarr]

the number of rows changes all the time, and the positions adjust automatically.

Hope this is of use, Rob.

 

[SkipVought]

In all these years of using MS Query, I never knew that you could do that. ==> *

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[robcarr]

i just tried and it works really well for me.
i am using access 2003 not tried on any other versions

Hope this is of use, Rob.