Combining two tabs

[lakh4u]

I have an excel workbook with two tabs, tab 1 has the people having access to case files details and 2nd tab has further details on the case file name, number and classification. Tab 1 has 212 people who have access to various case files and tab2 has 600 rows.
I need the query to combine both these and in essence repeat the 600 rows against the each person who can access a case file as they all will be having the same case files access.
Please help.

 

[ranman256]

in msQuery or msAccess, make a query to join the 2 sheets on case#,
you will get the result.

 

[lakh4u]

For some reason when i made a query the number of rows stayed 212 which is the no of rows on tab 1 instead of a combined value of 212*600 rows each in the query. Is there any setting which needs to be changes ?

 

[johnny51981]

Are you able to provide a sample of the two tabs?