concatenate a number of fields into a memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my database, there is a 'standard notes' table with text statements in a
field and also a 'show' field that is a yes/no type. I need to take all of
the sentences from the 'standard notes' field that have 'show' turned on, and
concatenate them together in one memo field in another table.

I'm not quite there with VBA yet to do this. I was thinking something with
for . . next using dcount.

Thanks in advance.
 
Are you concatenating the same field from multiple records? If so, do you
intend to combine all records with a show field of Yes or just a limited
group of records?
 
Yes, the same field from multiple records. All records that have the 'show'
field turned on.
 
Back
Top