Report based on two tables

[OOzy]

Dears


I have the following tbl2 and tbl2

Tbl1

EMPID, SALARY
1, 1000
2, 4000
3, 3000

Tbl2

EMPID, DEPENDENT
1, Joe
1, Mike
2, Larry
2, James
2, Loe
2, Lisa
3, Jeff
3, Ann

I would like to print a report like


1, 1000, Joe, Mike
2, 4000, Larry, James, Loe, Lisa
3, 3000, Jeff, Ann

How can I do this? I have posted this Access/VBA but did not get the answer I am looking for. Can anyone help?

 

[THWatson]

00zy
You need a method to concatenate the names in the Dependents' table.

Take a look at the RogersAccessLibrary site

http://www.rogersaccesslibrary.com/OtherLibraries.asp

and then under Hookom,Duane...his "Generic Function to Concatenate Child Records" that you can download.

Tom

 

[dhookom]

I also have the function here at faq701-4233.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.