Merging multiple queries with no link

[Tiana]

I have created several queries, each of them returns one column containing a list of numbers. The queries are not linked to each other in any way, and it's not possible to run only the one query to show the results I am after.

I would like to be able to see them all on the one page; just one column from each query, showing field name and results. Is this possible? I can't do it in excel because the data is regularly updated in Access.

I'm fairly new to Access, but am familiar with using the SQL, functions etc if required. I've already tried creating a link between the queries and doing various joins in SQL but it hasn't worked so far.

Any advice, whether simple or difficult, would be appreciated!

[CJ_London]

not clear what you are asking - you say each of them returns one column and one column from each query, showing field name and results - that's two columns.

I suspect you mean the field name is the column header.

If that is the case, suggest use a number of listboxes, one for each query (i.e the rowsource) and set column heads to yes

[Tiana]

Hi Ajax
Sorry, I should have said "only THE one column from each query". Yes, there is one column per query and I'd like them all to show on the one page, but there is no link between them.
I'm not sure what you mean, don't listboxes allow you to filter certain information? I'm not sure how that would help. Could you give a little more detail please?

[CJ_London]

don't listboxes allow you to filter certain information?

they can do, but they basically just list one or more columns of data - you would need to add code make them filter.

from your description, might look something like this

[Tiana]

Yes! This is what I'm after. I'll have a play around with it in the morning and see if it helps. Thank you