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.