I need to combine text fields into a memo field

[longbillduck]

What I have is a table with two fields

First field is the Cust_nbr and the second field is Notes. My problem is that I have multiple fields to combine in the Notes field.

Some records may have two fields that need combining and others may need as many as 10 fields; and still some cust_nbr records have no Notes to combine.

Is there a way to combine these fields?

Any help would be appriciated

 

[traingamer]

There is always a way.




Can you tell us where these other fields are?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[longbillduck]

Here is an attachment with a snippet of the table

 

[dhookom]

longbillduck,
You should take the time to type or copy and paste the significant information into your message. Many of us can't or won't open files for either security or attitude reasons.

Duane
Hook'D on Access
MS Access MVP

 

[longbillduck]

OK, I've added my original message, plus the section of my table at the bottom.




I need to combine text fields into a memo field
What I have is a table with two fields

First field is the Cust_nbr and the second field is Notes. My problem is that I have multiple fields to combine in the Notes field.

Some records may have two fields that need combining and others may need as many as 10 fields; and still some Cust_nbr records have no Notes to combine.

Is there a way to combine these fields?

Cust_nbr NOTES
10
11
14
50
50*10
50*20
559 Will pay by VISA on all orders.
621
655
655*10
661 Do NOT abbreviate their name when shipping as it
661 becomes confused with their neighbors packages.
665
668 Fax a copy of invoice to Janine Lane at AMAG @
668 555-725-3331 and mail original to Janine as well.
668*10
669 DEAR CUSTOMER,
669 IF YOU HAVE ANY QUESTIONS, PLEASE CONTACT US
669 APPL. GROUP AT 1-555-941-1900 THANK YOU!
669 Fax daily outbound manifest and invoices to
669 to the attention of Donna
669*1
669*2
669*3
4445*1
4450
4470
4470*10
6000 Prepay Charge
6000*1
6600*1
6600*10
6620 Broker is RA Farrow. Use Yellow Freight Collect
6620 per Allan to JRH 10/13/06, reconfirmed
6620 with Lee 3/10.

 

[dhookom]

So, you actually want to combine values from multiple records into one value. If this is the case, try faq701-4233.

Duane
Hook'D on Access
MS Access MVP