Combining Fields Question

[Ben Prusia]

Hello all, long time lurker, first time poster...

My question is:

I am trying to combine records on a 2 column database that looks like this:

REFNUM ARCHITECT
00000004 Pennington, John
00000004 Spencer, David
00000009 Minneapolis Bridge
00000010 Guthrie, A., and

But I want it to look like this:

REFNUM ARCHITECT
00000004 Pennington, John; Spencer, David
00000009 Minneapolis Bridge
00000010 Guthrie, A., and

I have tried all avenues to do such a thing, as this database will be posted
to the web in a flat file database, and I don't want a
user to search a database and end up getting 2 matches for one refnum
because they have 2 different architects.

Any help would be appreciated!

Ben Prusia
http://www.midwestbridges.com

Remove the SPAM filter to e-mail me!

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ben Prusia" <sp**********@kc.rr.com> wrote in message
news:sG******************@twister.rdc-kc.rr.com...

Hello all, long time lurker, first time poster...

My question is:

I am trying to combine records on a 2 column database that looks like
this:

REFNUM ARCHITECT
00000004 Pennington, John
00000004 Spencer, David
00000009 Minneapolis Bridge
00000010 Guthrie, A., and

But I want it to look like this:

REFNUM ARCHITECT
00000004 Pennington, John; Spencer, David
00000009 Minneapolis Bridge
00000010 Guthrie, A., and

I have tried all avenues to do such a thing, as this database will be
posted to the web in a flat file database, and I don't want a
user to search a database and end up getting 2 matches for one refnum
because they have 2 different architects.

Any help would be appreciated!

Ben Prusia
http://www.midwestbridges.com

Remove the SPAM filter to e-mail me!