Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Merging records

27 views
Skip to first unread message

rwpe...@clear.net.nz

unread,
May 9, 2013, 5:39:07 PM5/9/13
to
I have a table (ID, NewValue) I would like to merge all records with the same ID in to another field.....is this possible




bsn

unread,
May 10, 2013, 2:48:32 AM5/10/13
to

<rwpe...@clear.net.nz> skrev i en meddelelse
news:5750cfd5-0d6e-4700...@googlegroups.com...
>I have a table (ID, NewValue) I would like to merge all records with the
>same ID in to another field.....is this possible
>
>
>
U mean (NewValue NewValue NewValue NewValue)...With same ID
One solution could be a function with a little VBA programming...
Bjarne


Bob Barrows

unread,
May 10, 2013, 6:15:59 AM5/10/13
to
rwpe...@clear.net.nz wrote:
> I have a table (ID, NewValue) I would like to merge all records with
> the same ID in to another field.....is this possible

Sample data and desired results please. Your explanation makes perfect sense
to you, I'm sure, but "merge" in database terms probably does not mean what
you intend.


Joan Wild

unread,
May 10, 2013, 11:36:09 AM5/10/13
to
rwpe...@clear.net.nz wrote:

> I have a table (ID, NewValue) I would like to merge all records with
> the same ID in to another field.....is this possible

You wouldn't want to concatenate the items into a new field in a table,
as that would be redundant.

However you can accomplish this in a query using a function like:
http://access.mvps.org/access/modules/mdl0008.htm

0 new messages