Join queries that do not have matching field

[ppataki]

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

 

[highandwild]

It seems a bit unconventional what you are trying to do.
Why not just export the data to Excel, cut and paste in Excel and then import back to Access.

Does it matter which record in one query matches up with another in the other queries?

 

[ppataki]

That would be very manual and I would like to stay in Access
The reason for being unconventional is that the data that I need to work with comes in a very unconventional format and cannot be changed

 

[highandwild]

Can you add an autonumber field to each table and then you will be able to join using this field.

I not, then create new tables with an autonumber field and append the existing data to those tables before joining them in a query.

 

[ppataki]

The second method works fine, just a little extra work
Thank you!

 

[highandwild]

Glad you got there in the end.

I'm off to the beach now.......