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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

insert memo feild into a memo field truncates at 255 characters - 4
3008 error by using memo format 0
Scanning Through "Memo" Field Is Very Slow 5
Insert large base64 into memo field 4
Insert (Append) text into a memo field 11
Inserting a concatenated string into a text field 2
Import WordPad RTF file into an RTF Memo field in Access 2007 1
Access Dcount (multiple criteria) 3

Back
Top