Collapse into a single row.

[pon]

I combine two table person_id and benefit_id to get the following result
Angela, 07-10-1990, MEDICAL, 03mem
Angela, 07-10-1990, DENTAL, 04mem
Angela, 07-10-1990, VISION, 01mem

What kind of query should I use to get the following result?
Angela, 07-10-1990, MEDICAL, 03mem, DENTAL, 04mem, VISION, 01mem

Please help.
Thank you

 

[MGFoster]

I combine two table person_id and benefit_id to get the following result
Angela, 07-10-1990, MEDICAL, 03mem
Angela, 07-10-1990, DENTAL, 04mem
Angela, 07-10-1990, VISION, 01mem

What kind of query should I use to get the following result?
Angela, 07-10-1990, MEDICAL, 03mem, DENTAL, 04mem, VISION, 01mem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Often asked question. Here's an answer:

http://www.mvps.org/access/modules/mdl0004.htm

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSfIOMIechKqOuFEgEQJtFgCg4hMLqJJGGIl4Cmb8DcQhyI4b4bsAoIax
SVjXOViWn23BunaCUC9Iaphq
=P86V
-----END PGP SIGNATURE-----