combining 2 tables

[psrs0810]

I have a list of Depts in one Table and a list of Id's in another.
What I want to do is for every dept. I want every ID listed.

So if I have Dept 1000 and I have Id's 1-85. I want 1000 1, then 1000 2, then 1000 3, etc.


THanks

[RuralGuy]

You are going to have to be a little clearer as to what it is you want and where you want it.

[psrs0810]

Ok, let's say I have 4 depts (1000, 1001, 1002, 1003) and instead of 85 ID's, let's say I have 3 ID's (A, B, C)

I want to bring together in this format:
1000 A
1000 B
1000 C
1001 A
1001 B
1001 C
1002 A
1002 B
1002 C
1003 A
1003 B
1003 C

[RuralGuy]

That part is understandable. Where do you want this information? In a report, a form, a table?

[psrs0810]

Let's go with a table.
I will end up using those results to pull other information.

thanks

[RuralGuy]

Are the ID's in separate records in the second table?

[psrs0810]

I have Depts in one table and ID's in a seperate Table

[RuralGuy]

I understand that. Please re-read my question in post #6.

[psrs0810]

are you asking if eash Id is in it's own cell? Then yes.

Otherwise I am not sure what you are asking.

Thanks

[RuralGuy]

Sounds like you may be coming from a spreadsheet background. Is there a Row in the ID table for each ID as opposed to one text cell with "1-85" in it.

[psrs0810]

Definitely a spreadsheet background
Yes each row contains an ID

[RuralGuy]

You can make what is called a cartesian product by creating a query and dropping both tables in it without a Join. You will then get a separate record for every combination of the two tables which it sounds like you want. You can control the output by sorting as you desire. Post back here if you need further assistance.