Update field

[Lori]

I have a talbe that has duplicate client ids with
different memo fields. I want to update the memo field so
they are joined together. (one is 5% 100 one is 7.5% 200)
want it to say 5% 100 7.5% 200).

I have been able to isolate the payments I need to do this
on but it wont update since it is a calculated field.

What I'm ultimatley trying to do is to put two interest
payment amounts on one check but have the detail of the
payment in the memo field. I use the table to create a qif
file for quicken.

Thanks in advance for any help

Lori

 

[Guest]

There's sample code at http://www.mvps.org/access/modules/mdl0004.htm to take
multiple records and concatenate a field.