Join queries that do not have matching field

[Petefured]

Dear All,

I have multiple queries that I would like to "put the fields next to each other"
each query has the same number of records and only one field
These fields in each query has nothing to do with each other (ie I cannot make a join from them)



I tried putting them in a query next to each other without creating joins but the result was not satisfactory as Access combines their records so if I combine 2 queries and there are 3 records in each query then the resulting query will have 9 records....but I would only need 3

Could you please advise?
Many thanks in advance

[TheShabz]

If your table contains less that 65,535 fields, export it into Excel and paste them next to eachoter.

[pbaldy]

An alternative is to present them as 3 subforms/subreports right next to each other.