Help combining two quieries to output

[AccessUser1234]

Hello,



I have two quieries that I have sorted out to.
A Table: Fields in this table are: Record Type, Number, Dept, Spaces
B Table: Fields in this table are: Record Type, Pay Type, Shift, Week,Hours, Position, X Dept, Code, Ent

My goal here is that I want to combine these two quieries and export them to one file. I need them to read the following in the export file.

Record from A table
Record from B table
Record from A table
Record from B table

The B table is in relationship to the A table. I need it to read like that for each record in the quieries. I cant figure out how to do it. I can create a common identifier between the two tables (emp ID) but i still cant figure out how to do it. I have all the information there i just need to like shuffle the information, so i can get it to output correctly.

Any Ideas would be greatly appreciated. .

Thanks

[pbaldy]

Not clear on what your data looks like, but it seems like you may want a UNION query:

SELECT Field1, Field2
FROM Table1
UNION ALL
SELECT Field1, Field2
FROM Table2

[AccessUser1234]

Hello,

I need my data to look like this.

B 0000099900000892900
C 01001000040.0001000067000
B 0000012300000998800
C 010001000035.000100088000

The C record is unique to the B Record. The information is in 2 tables B and C, but i need some way to get them combined to.

I tried to use a union query but it wasnt working. For union queries shouldnt the fields be similar? For this this fields arent similar the only common identifier is Emp ID if i would add it to the quiery.

Everytime I tried to to the union query i kept getting a syntax error saying that it could not find record type. I am new to union queries so not sure what that means.

Thanks for your help

[pbaldy]

Can you post a sample db with the two tables and what the desired result is?