Help with a join query

[abordeau]

Helllo,



I am trying to create a weekly schedule form an excel spreadsheet that is quite horribly designed. (redesigning it is not an option). I am responsible for picking the proper information off this schedule and putting into a much more user friendly form for our supervisors. I used single queries to get the information that I need, now I need to join them some how that doesn't put them in order by column. I would like them to be organized by row.

Eventually I will be creating a macro and form for this as well.

ex.

Monday Mechanics
Monday Electric
Tuesday Mechanics
Tuesday Electric
ect.

I have attached a copy so you can understand what I mean.

Thanks in advance for any help you can give.

Angelina

[pbaldy]

You might try importing the linked Excel file as an Access table and reposting the sample (it won't work for anybody but you as is).

[abordeau]

I tried to convert the xlsx file into an access table but for whatever reason it made file to big to upload. I even tried to compact it but it still wasn't small enough. So I attached a zipped copy of the xlsx file. Hopefully you can open it.

[pbaldy]

I'm not clear on the result you're after. You can stack the results as separate records with a UNION query.

[abordeau]

Right, thats what I'm after. I can't figure out how to do this without the results repeating themselves

[pbaldy]

I don't get repeat values with this test:

SELECT [1st shift Friday-Elec].*
FROM [1st shift Friday-Elec]
UNION ALL
SELECT [1st shift Friday-Mech].*
FROM [1st shift Friday-Mech]

[abordeau]

Thank you

I don't get repeat values with this test:

SELECT [1st shift Friday-Elec].*
FROM [1st shift Friday-Elec]
UNION ALL
SELECT [1st shift Friday-Mech].*
FROM [1st shift Friday-Mech]

[pbaldy]

Happy to help, particularly somebody with a name I like so much I gave it to my daughter.