By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Combining Fields Question

P: n/a
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!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.