basement131
Technical User
i have 2 tables whith the following
table 1 called [JC]
this table only has the job codes which are numbers such as 120, 121, 122, 150, 180, 250, 260, 320, 390, 450, etc.
table 2 called [JL]
this table has the job locations in which there are only 4 locations as follows: C440, S440, R440, & R442.
i need to create a query (which i need for a different query) which will do the following.
I need to create 4 records for every job code. i will have 2 collums collum 1 will have job codes and collum 2 will have the job locations. Every job code can be at 1 of 4 locations. for example
JC location
120 C440
120 S440
120 R440
120 R442
121 C440
121 S440
121 R440
121 R442
etc
please provide assistance
table 1 called [JC]
this table only has the job codes which are numbers such as 120, 121, 122, 150, 180, 250, 260, 320, 390, 450, etc.
table 2 called [JL]
this table has the job locations in which there are only 4 locations as follows: C440, S440, R440, & R442.
i need to create a query (which i need for a different query) which will do the following.
I need to create 4 records for every job code. i will have 2 collums collum 1 will have job codes and collum 2 will have the job locations. Every job code can be at 1 of 4 locations. for example
JC location
120 C440
120 S440
120 R440
120 R442
121 C440
121 S440
121 R440
121 R442
etc
please provide assistance
