database - Trying to combine results of Access query in new field -

i have access database tracks bid numbers in 1 table , person/persons working on bid via 1 many relation linked id field in table. trying consolidate results when there multiple people working on bid results can bound report field. not having luck in scouring internet. small example below.

typical result:

table 1 table 2 table 2 bidid   bidid   quoter 100         100  rar 101         101  rar 101         101  abc 101         101  hij 102         102  abc 103         103  rar 103         103  abc 

result want:

table 1 table 2 generated result bidid   bidid   combined field 100         100  rar 101         101  rar, abc, hij 102         102  abc 103         103  rar, abc 

any appreciated. thanks, ron